Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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...
Need Help
ThijsL's avatar
ThijsL
New Member
8 years ago

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").

Ruchita's avatar
Ruchita
Helper I
2 years ago

Hi,

I am facing the same issue. After every refresh in Power BI service, the figures on the visuals change. Like value for different projects is showing different on every refresh but the total value is always the same. I tried to add sorting the tables but then refresh on the desktop itself seems to go on infinitely. Can you help?