Forum Discussion
Power query too slow
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:
5 Replies
Can you share maybe 2 files with dummy data and provide expected result based on sample files?
