How can we improve Power BI?

Allow the use of ORDER BY when querying a SQL Server View in DirectQuery

When using PowerBI in DirectQuery, you cannot query a SQL Server View with an ORDER BY without receiving the SQL Server error message

"The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified."

While I understand we cannot include an ORDER BY in the SQL Server View Definition, we should still be able to issue an ORDER BY against a pre-defined View (or utilize the Query Editor for Direct Query for sorting, etc.)

23 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.