Forum Discussion
Rows not sorting properly
I have a dataset with a column called row number that is imported from the smartsheet, the row number runs from 1-1901, incremeting by 1. In PowerQuery it loads in numeric order. In the Data Model, i...
Neither Power Query nor Power BI give any sorting guarantee unless you specify how you want stuff sorted. Adding the index is the right first step. Next step is to use the "Sort one column by another column" feature.
I did use the sort by column option, I used the index to sort the row # column and it still starts with 649