Python Export Column Sorting Changes

[numersoz]

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?

[v-lili6-msft]

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://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column#sort-using-the-sort-...

https://radacad.com/sort-by-column-in-power-bi

Regards,

Lin

[numersoz]

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.