Forum Discussion
Each data refresh gives different data results
Hi Anonymous
Add an "order by" clause to the source query - that solved the problem for me. The issue only starts once the data volumes get really high. Power BI seems to run the query twice, getting the first x rows in query 1, and then total-x rows in query 2. It assumes that the order is the same, and then you get some duplicates and some missing records.
Let me know if that works for you too.
Thanks
Ina
Hi lizrowden, Anonymous
Below is a link describing the full details of the issue that I had, and how I finally resolved it.
The conditions under which it occurred are:
- High volume source data
- Subsequent merge
(note: the query doesn't neccessarily have to return high volume data. It's the source table size that seems to determine this)
https://community.powerbi.com/t5/Issues/Power-Query-Merge-yields-inconsistent-results/idi-p/119485
The easiest fix was to add an explicit "order by" clause to my source query.
Hope this helps
Ina