Forum Discussion

EHISAdmin's avatar
EHISAdmin
Frequent Visitor
3 years ago
Solved

Cache Will Not Clear - Desktop

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

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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