Forum Discussion
Powerquery - Returning data as Tables seems to cause memory thrashing beyond certain point?
I'v collected some more performance tips on my site here: https://www.thebiccountant.com/speedperformance-aspects/
Although the specific problem JeffWeir mentioned is not covered there unfortunately it covers some aspects that should always be checked / tried out when performance problems occurs.
What I would try as a last resort is to keep the problematic query loaded only to the data model, reference it again in the query editor and then load that to the sheet. With any luck, this will trigger a totally different evaluation plan that doesn't have those problems.
Hi JeffWeir ,
It seems that you have memory issue when refresh queries in query editor?
Do you get any error message? If you have error, could you share the screenshot of the error message?
I think you could describe your scenario with images so that we could understand it better.
In addition, you could refer to this blog which provides the tips for performance in power query.
ImkeF any other ideas?
Best Regards,
Cherry
I'v collected some more performance tips on my site here: https://www.thebiccountant.com/speedperformance-aspects/
Although the specific problem JeffWeir mentioned is not covered there unfortunately it covers some aspects that should always be checked / tried out when performance problems occurs.
What I would try as a last resort is to keep the problematic query loaded only to the data model, reference it again in the query editor and then load that to the sheet. With any luck, this will trigger a totally different evaluation plan that doesn't have those problems.