Forum Discussion
Stuck on "ApplyQueryChanges"
I am working with a CSV file that has multiple items in a single column which i wanted to seperate out to be able to filter out charts. I am doing as it says in this solution: https://community.powerbi.com/t5/Desktop/How-to-separate-values-in-chart/td-p/54220
However, when i apply the queries it just gets stuck on Apply Query Changes 68KB. The file size is 2.1MB.
Is there a way to solve this issue? I've left it for 3 hours and nothing
7 Replies
Anonymous , can you please share the version of power bi you are facing this issue.
File -> About
hi amitchandak i have just updated to Version: 2.88.1385.0 64-bit (December 2020)
Anonymous , There was no such issue reported on Dec 2020. Can just try this with a new file. Also, check RAM and CPU utilization of the system. is it too high.
Hi Anonymous , try clearing the cache and temp files on your local drive.
Temp files:
C:\Users\xxxxxxx\AppData\Local\Microsoft\Power BI Desktop\TempSaves
Cache:
Options > Global > Data Load > Data Cache Management Options
Reference: https://www.fourmoo.com/2018/01/16/power-bi-loosing-disk-space-when-working-with-power-bi-desktop/
Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.Hello.
Solution is table.buffer. My power query stuck 20 hour. And over 200 GB, same problems. Solution is use table.buffer on correct position. Before functions. First buffer the table and call function with buffered table.
