Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am unable to clear the cache in my Desktop without manually deleting the cache file (if I can find it) or completely deleting all Power BI installation and app files and reinstalling the Desktop app.
I use several reports that are very large (>50 million rows over >40 tables) connected to a SQL server. (model sample below) I use aggragation where I can but the users require granular data at the row level. When a report refresh encounters a load error, I usually find that the issue is an overloaded cache and clearing it fixes the issue. However, I am now frequently getting the "Something went wrong" error when attempting to clear the cache. (see attached) The only solution to fix this I have found is to wipe the Desktop app and all related app files, then reinstall the app.
Help?!?!? 😧
Error view
Model Snapshot
Solved! Go to Solution.
@EHISAdmin , You should be able find cache here
C:\Users\<User name>\Microsoft\Power BI Desktop Store App\TempSaves
Also, close all power bi instances and try again. Increase memory management cache to 8 to 10 GB
@EHISAdmin , You should be able find cache here
C:\Users\<User name>\Microsoft\Power BI Desktop Store App\TempSaves
Also, close all power bi instances and try again. Increase memory management cache to 8 to 10 GB
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |