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 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.

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

5 Replies

    • 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.