Forum Discussion
Each data refresh gives different data results
Hello, I created a .PBIX file with a model and it has been working correctly for 3 months. Data sources are SQL Server 2014 and some Excel worksheets. After updating Power BI Desktop to the lat...
Sorting the tables which are loaded into your diagram set-up seems to work.
You can add this as a last step in the query of each table by clicking on the column with the most unique data and sort a->z.
Had to do this for each table separately both for the data tables and the labeling tables (labeling as in merging hierarchy levels with key fields of the data table or just one like "manager" adding to each "projectkey").
I would go one step further and modify the power query for the sort by wrapping thesort code in a Table.Buffer() to ensure the entire table is sorted and not just the viewable delegation.
I do this anytime there is a sort or remove duplicates step to ensure proper data management with large tables.