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
InaNortje's avatar
InaNortje
Advocate I
8 years ago

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

 

 

Ruchita's avatar
Ruchita
Helper I
2 years ago

I am also facing the same problem. After every refresh from Power BI service, the data in the reports changes. My data is on BigQuery and I have created views from where I am pulling the data into PowerBI. I tried to sort the tables in power BI using sort but the refresh in power BI desktop is going on infinitely. So I tried by adding Order by clause in the views in BigQuery. But it didn't help. Still the data changes on every refresh.