Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am using Python scrpit to pull data. On Jupyter Lab the pd dataframe column order is just fine. But when I export data on PowerBI using the same exact script, column name orders to alphabetical by itself.
Does any one have an idea why this would be the case?
hi @numersoz
In power bi, the data is sort by alphabetical by default.
And you could use "sort by column" to custom it. see more details as below:
https://radacad.com/sort-by-column-in-power-bi
Regards,
Lin
Hi it is alphabetical by default on modelling view but not on Power Query. It is by the original column order there. All other data sources I export are by original order except for the one that I am trying to get from Python.
When I run the Python code outside of PowerBI it is working but just inside Power Query it is not by the original order.
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |