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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

This is indeed really annoying, I am facing same problem since last three day every single time I refresh it gives me different results L I am using Power Bi latest release September. Also using SQl Server 2012, I tried using SQL Server 2016 No change in behavior. Can someone please respond

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

 

 

  • InaNortje's avatar
    InaNortje
    Advocate I
    8 years ago

    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

     

     

  • 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.