Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
New here and hope to find someone ready to help me. My Excel Power Query app is loading data from a folder. The datas have, for some column, different headings so i found a workaround on youtube: I created a list of the headers, made it unique, converted to a table and then filtered and loaded back again to expand the new table. I hope I've been clear enough.
From this moment on power query turns really slow in loading the data and I'm pretty sure the issued step are the ones I have of the Heading list and the Filtered Heading list. I attach below some image representing the steps used.
Really hope someone can help in improving the script and make it faster, maybe even using another workaround to reach the point I need.
Heading List:
Heading list
Heading list converted to table:
Filtered table from unwanted values:
Heading list filtered:
Final result with expanded table of filtered headings:
Thanks for reply. I actually can't, the files are restricted. If you need some more information by screenshots or direct formulas I can provide.
many thanks
I'm sorry about that but as said, I'm not able in any way to directly upload the files. Is there any suggestion you can give me to better understand why the list of headers slow down so drastically the power query steps?
Check out the July 2025 Power BI update to learn about new features.