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 spe...
STATUS
DETAILS
New