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 Petr_Strejc

 

Excellent description of the issue!  Thank you very much for providing steps to recreate the issue. 

 

I sent a request to Chis Webb to have a look at this issue.  Of all the people I know, he is most familiar with Power Query and M, and he has good contacts at Microsoft who may take up the issue. 

 

Another person that may be able to help is Koen Verbeeck.  

 

Regards

 

Ina

 

 

hbarber's avatar
hbarber
Regular Visitor
8 years ago

Hi there,

Has there been any update on this?

I have just created a report on PowerBI but each time I've refreshed it today I get a different total.

The underlying data is pulling from SQL tables which are updated overnight so that data is not changing inbetween refreshes.

Initially it took 7 refreshes to get the figure I was expecting but then I just kept refreshing to see how many times it would take to get that figure again and it took 18 times, then 7 again.

Any help would be greatly appreciated!

Thanks

Harriet

 

  • Matty's avatar
    Matty
    Helper II
    8 years ago

    Hi,

     

    Any news on this?

     

    I don't know how prevalent the issue is, but it feels like a fairly fundamental problem that needs addressing.

     

    Cheers,

     

    Matty