Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi everyone, been struggling figuring out why would power query not combine headers with the same name from multiple excel files. The orders of columns is not the same, but I thought power query combines based on header name? TYA!
Solved! Go to Solution.
Hi, @ickest ;
You could refer to those video.
https://www.youtube.com/watch?v=wKglApDFMog
https://www.youtube.com/watch?v=sb0hmwiFM-E
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @ickest ;
You could refer to those video.
https://www.youtube.com/watch?v=wKglApDFMog
https://www.youtube.com/watch?v=sb0hmwiFM-E
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm trying to append all excel files from a folder (source is folder).
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |