Forum Discussion
Inconsistent Data After Refresh - Merge Query Issue (?)
Hi all, I encounter a very strange issue/behavior in PBI, which I suspect has something to do with the way merge transformation is used in PowerQuery. Basically, I extract data from SQL Serve...
I think I have found a solution by the power of SQL query. Instead of adding an index column in PowerQuery, after getting the data, I'm using ROW_NUMBER in my database SQL:
SELECT ROW_NUMBER() OVER( ORDER BY Column1, Column2) id_Num, Column1, Column2 [...]
So far my indexes have behaved on refreshing in the PowerBI Service. Hopefully it stays that way...!
Just to update, I've been using this approach (SQL ROW_NUMBER to add an index) since September and it is still working very well, without any problems, and is fast.