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

I've had this same issue.

 

Sometimes I even get an error message saying there was a duplicate value in one of my tables. I then refresh again and it pulls through, but as before, the data is giving different numbers

 

Really feels like it's doing something different everytime I click refresh

kdecolve's avatar
kdecolve
Regular Visitor
8 years ago

Hello 

 

I figured out that there was a problem with the merge query. 

 

I solved this by merging the tables in SQL Server. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi kdecolve do you have any more detail on how you found the problem? I'd rather stick to merging my queries in Query Editor rather than in SQL Server.

     

    • InaNortje's avatar
      InaNortje
      Advocate I
      8 years ago

      Hi Anonymous

       

      Do you have an explicit “sort by” on each of your source queries?  If not, just update them all with an explicit sort.  That did it for me, so I was able to still use the Power BI Merge function.  Hope this may help.

       

      If that’s not an issue in your case, let me know and I will give you some pointers on how to find out the cause. 

       

      Regards,

       

      ina