Forum Discussion
Each data refresh gives different data results
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
I am also having this exact issue. It seems to appear when I'm using an SQL Stored Procedure and passing variables to it (the variables are taken from another table to allow the user to change them before execution). I also put some logging in the Stored Procedure and the 1st time the query is refreshed (after changing the variables) the Stored Procedure gets executed anywhere from 4 to 11 times and returns duplicates and missing data! Any subsequent refresh only executes the proc once. I've also captured the raw results before they are sent to Excel. All return the same results set with the same counts so it's defintely something Power Query/Excel is doing.