Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Click and drag 🙂
Proud to be a Super User!
@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
Thank you all for this great help. I appreciate it
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.
@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
Click and drag 🙂
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |