tables order in Power Query

[lastnn30]

Hi

I have like 12 tables in an excel files. I uploaded them all at once to Power Query. The order of these tables are wierd to me. Please screenshot below.

What I do not understand, why Text_Ex3 is before Ext_Ex2

Text_Ex3

Text_Ex2

And why Text_Ex6 is before Text_Ex5

Text_Ex4

Text_Ex6

Text_Ex5

Text_Ex7

Thank you very much.

[ChrisMendoza · Accepted solution]

@lastnn30 -

Click and drag 🙂

[lastnn30]

Thank you all for this great help. I appreciate it

[jaipal]

@lastnn30 i think it is depending on the file size. 

You can re arrange the order.

[lastnn30]

Thanks for your help and reply. It is one folder which has multiple tables. I tried it again today (transform tables) to power query and all the sudden the order is fine today!! please see screenshots. Yesterday the order in PQ was not right but the order in PBI is right. Today both are right. 

I am just curious, you said you can re-arrange these queries in PQ, how?

Thank you so much.

[jaipal · Accepted solution]

@lastnn30 I am not sure why the PQ behaviour is weird. In the Power BI, the order would be alphabetical. 

If you want to rearrange the orde of the tables, just click and hold then move up and down

[ChrisMendoza · Accepted solution]

@lastnn30 -

Click and drag 🙂