Optimize Power BI Queries -- 3

Job ID: 39337764

Budget: £20 – £250 GBP

I want to remove helper queries in Power Query which show when importing a files from a folder without slowing down the main query. I have attached a file that you can put in a folder to test

Requirements:
- Expertise in Power BI and Power Query
- Experience in optimizing queries for performance


The key thing here is I need the load speed to be the same after removing helper columns as with. I already know how to remove helper columns but when I do it the load speed goes up by 100 times. So this project will only be accepted if you can make load speeds the same.
Related categories: SQL Power BI