January 8, 2020
My problem is regarding Power Query. Please see the attachment.
I have connected 7-8 different files into one file to have my final analysis as a result. Individual queries (which is created when new file is connected) which are also having calculations work absolutely fine.
My last query named as "Stock Summary" is creating problem for me. This query just has to fetch ready-made calculated fields / columns / records from another queries.
My question is, if dependent queries are working fine (refreshing quickly), then why result query is taking too long time?
Request you to guide please.
July 16, 2010
This post has some ideas on how to speed up Power Query. It's obviously not the small file causing the issue, it's more likely the other query you're merging, or changes you've made to that small file along the way. It's difficult to troubleshoot without seeing the queries, but hopefully that link will give you some ideas.