Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Power BI Desktop Version 2.42.4611.701 64-bit (January 2017) - though earlier versions seem to have the same issue
Data Source SQL Server 2016
When using a Power Query merge in my Power BI Desktop file, the results in the data model are inconsistent every time I refresh. No error is reported - the data is just never correct.
Some rows are dropped, and others are duplicated. Every refresh returns a different set of rows, so it does not consistently include/exclude/duplicate specific records. There is always either 0, 1 or 2 of each row. Never more than 2.
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.
Similar issues were reported in the links below, but I cannot see a resolution on any of them.
https://community.powerbi.com/t5/Desktop/Each-data-refresh-gives-different-data-results/td-p/60989
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.