Forum Discussion
Anonymous
10 years agoNot applicable
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...
Anonymous
8 years agoNot applicable
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
8 years agoAdvocate I
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