Forum Discussion
Each data refresh gives different data results
Replying to thread to let others know that I am encountering the same issue (two different results based on the same source refresh. The model is a bit more complex and there is a lot going on with alot of source data). My version is: 2.57.5068.721 64-bit (April 2018). Current temporary solution for is to revert to previous working copy.
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").
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?
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.
