Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
4 years ago
Solved

tables order in Power Query

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...
Need Help
  • jaipal's avatar
    jaipal
    4 years ago

    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

lastnn30's avatar
lastnn30
Post Patron
4 years ago

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's avatar
jaipal
Resolver III
4 years ago

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