Forum Discussion
Solved
'Sort by Column' setting gets lost when using Power BI Data Set
I've created a Data Set and published to Power BI Service. I have a 'Sort by Column' set on one of the query columns and this works successfully in the original .pbix. However, when I use the publ...
@jbrown_99 if you connect to Power BI Dataset, you must add this sort by column to the original Power BI dataset file, and then it will work on the file that is connecting to the Power BI dataset.
Hi jbrown_99 , are you simply using a "live" connection, or are you attempting to make additional model changes using the new "DirectQuery for Live Connections" preview feature?
If the latter, "Sort by Column" is one of the initial limitations listed with the release of that feature.