Forum Discussion
Power Query Table != Power BI Table
Replicated the query on a csv extract, no problems if it's a connection to csv. Something with the connection/connector is bugged.
It turns out that this particular connector repulls the query at each applied step, and as the query randomizes the data pull every time it breaks the order of items. The solution is to sort at the very top of the query to lock the sort order. This negatively impacts query refreshing and editing quite a bit so heads up on that.
I also discovered Power BI is changing the sort order for every single step in Power Query, even though each step is not giving a sort command.
Replicated the query on a csv extract, no problems if it's a connection to csv. Something with the connection/connector is bugged.
It turns out that this particular connector repulls the query at each applied step, and as the query randomizes the data pull every time it breaks the order of items. The solution is to sort at the very top of the query to lock the sort order. This negatively impacts query refreshing and editing quite a bit so heads up on that.