Forum Discussion
High CPU usage in Excel after query refresh
Thanks edhans,
There are only 2700 rows, but I have seen a possible lead from a similar question I has about filling the rows, from where I got the original code segment : https://community.powerbi.com/t5/Power-Query/Filling-blank-values-in-a-dataset-based-on-a-shared-value-on-a/m-p/983037#M33790
Going to look at this.
Thanks again
There are not enough details to diagnose this issue. The code provided in this form cannot be malicous so that isn't it. You can have some code that works great for 10,000 to 1,000,000 records, but that same code can be extremly inefficient at 10,000,000 records.
One thing you can try is to disable all of the Column Profile, Column Distribution, and Column Quality features in Power Query on the View tab. Those all cause additional processing as Excel is evaluating data to return those charts. Very helpful, but I disable if I am working on a complex step or a lot of slow data (CSV files).
Barring that, your best bet may be to just restore to a previous version in OneDrive/OneDrive for Business/SharePoint.
Thanks edhans,
There are only 2700 rows, but I have seen a possible lead from a similar question I has about filling the rows, from where I got the original code segment : https://community.powerbi.com/t5/Power-Query/Filling-blank-values-in-a-dataset-based-on-a-shared-value-on-a/m-p/983037#M33790
Going to look at this.
Thanks again