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
Icon for Advocate I rankAdvocate I
9 years ago

Hi v-micsh-msft

 

I seem to have a very similar issue as posted here.

SQL 2016 and Excel data sources.  Every time I refresh, I get a different result set appearing on my reports.  Some rows are missing, others seem to be duplicated.  Each refresh yields a slightly different result set, and each time it is incorrect.  

 

I created the model and handed over to a business user late November 2016 year.  About 2 weeks ago the user reported that some historical results kept changing.  I am not sure at which point exactly this issue started, but I am now troubleshooting the issue on Power BI Desktop version 2.42.4611.701 64-bit (January 2017), and getting this strange behaviour consistently.  The user reporting the issue is running the November release, so it seems to be across different versions of PBI Desktop.

 

Can I go ahead and add to this post, or should I open another thread?  I have the trace logs ready.

 

Regards

 

Ina

lizrowden's avatar
lizrowden
Icon for Helper I rankHelper I
9 years ago

I am also having issue. Has anyone found the cause or a solution? I am on the latest version of the Power Bi desktop. The data in the query editor is fine and the same number of rows are returned, but everytime I click the Refresh button on the report I get a different result even though the underlying data and report has not changed.