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.
@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.
Thanks everyone! Yes, this was user error. I double checked my original .pbix data and I'd lost the Sort By in it. After reassigning the Sory By and republishing the data set, it only took a simple refresh the second .pbix to see the Sory By working.