Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I was wondering if anyone knows how to preserve the sort order of a source when importing data from a SQL query. There is no order by defined, but the way the data is returned in regards to the sorting, can that be retained? If not will the addition of Order By in the SQL Query help? If that again is not possible, is the only way to do this is by sorting by different column names, or by defining a sort value column?
Thank You
Solved! Go to Solution.
hi, @nirvana_moksh
It will keep the same sort order with SQL query code.
If there is order by defined, it will keep the same sort order too.
Best regards,
Lin
hi, @nirvana_moksh
It will keep the same sort order with SQL query code.
If there is order by defined, it will keep the same sort order too.
Best regards,
Lin
Hi have the same problem but it think the problem is more related with the visualization table.
I have a view in SQL server, the view has a specif sorting (ORDER BY), when I "get the data" and go to "Trasform Data" view, the data looks OK, but when I load the data to a "Table", I'm missing the sort of my view.
Is this a bug of visualization table?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |