Forum Discussion
Power Query running extremely slow
Hello Experts,
I am working on a project where my PQ is connected to a folder in which there are three subfolders (One having 95 PDFs around 100KB each, second having 30 PDFs around 300KB each and the third one is 30 Excel files (.XLSX) 12KB each)
My PQ has suddenly become too slow and clicking on each steps it keeps buffering. I tried with covering some steps (merge queries and group by) with table.buffer or table.stopfolding but it is not helping. I clicked on "Never allow data previews to download in the background" and still it doesn't improve the performance. If it takes 5 minutes or more for one step then it is too time consuming.
Please help how can I improve the process.
Thank you,
Vinesh.
4 Replies
Hi vineshparekh ,
is that folder on a local machine or in the cloud? (SharePoint, Onedrive)?Hi ImkeF
The folder is in the shared drive. It's not on SharePoint or OneDrive but a folder is shared among team members.
Thanks.
Try making a copy of the folder and subfolders (if there are any), save it to your local machine, and see if they run normally. I have a question, are you on wireless when connecting to the shared drive?
Ok, so there is no fast gain to be made then.
Hard to tell from the distance, but for merge and group a buffer usually isn't benefitial.
I have collected some performance improving adjustments here:
Speed/Performance aspects – (thebiccountant.com)
You might want to go through them to see what could work for you.
