PowerBI Desktop, Version: 2.56.5023.942 64-bit (March 2018)
I have downloaded a pbix file and opened it in PowerBI Desktop. The data source is a PowerBI Service and the lack of Data or Relationship tabs indicates it's a SSAS solution.
When I put some of the data (accounts) into a matrix and sort by the account name it actually sorts by the account number. This leaves the account names in a seemingly random order. I want to confirm that the model is set to sort by another column. Ideally I'd be able to turn this off.
Is there a tool I can use to view the queries? Apparently I can't use DAX Studio because it only works with imported models.
Is there a means of turning off "sort by another column" when I don't have access to the model?
I don't think you can do this. The documentation says "You can create report level measures in the Power BI Desktop, but all other query and modeling features are disabled when exploring live data". Can you reach out to the author of the model?
Clicking on the menu at the top to sort asc or desc sorts it by the associated field rather than the displayed field.
As you both have suggested, I'm going to have to go back to the original developer.
Except that it's not my cube. It's a PowerBI Service.
Surely there's a way to say, "that's a great recommendation, but I don't want to sort by that field. Thanks all the same."