Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 published data set as a new 'Power BI Data Set' source in for another Power BI desktop .pbix, the 'Sort By Column' functionality is not working and I don't see a way to update this in the .pbix - since the data set is from the Service. Any thoughts super appreciated.
Solved! Go to Solution.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
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.
@jbrown_99 , May be republish and try again.
Also, check when clicking on the base column, do you see the sort column option under column tools. This should be accessible from visualization view, if available
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |