Forum Discussion
Power Query Refresh Speed is very slow
Below applied step in my power query is normal. However, after I inserted below two steps before above step, the refresh speed becomes very slow Not sure what happens, anyone know...
Thanks so much for your reply, but it does not work, above is my whole M Code, can you find the key issue which resulted in the slowness performance?
Hi AshaZeng,
Sure, I'd be happy to help you improve that query. Here are a few suggestions to get started:
- Remove redundant steps (such as reorders and renames)
- Consolidate value replacement steps
- Combine new field creation steps
If you need further assistance, please share a link to an excel file with representative dummy data, including the current state of your query. You can upload it to OneDrive or Google Drive, ensure it is accessible for anyone to download.
I hope this is helpful