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.)
LSU BOB commented
Any resolution or workaround to this problem?