cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Data Cache size in PowerBI desktop

Hey,

 

We have a bit of a random setup whereby we use a number of hosted VMs and get assigned onto one of these each day when we login by an automatic load balancer. We use PowerBI a lot (desktop) across multiple users. We're finding the VMs keep running out of disk space as different users are building up a PowerBI cache across the 5 vms we use, the problem is, they can't clear the cache as they might not be logged into that machine that day - so you tend to get impacted by other users previous caches on that particular VM.

 

The cache is set to 4gb - can we control this as part of group policy? (as reducing to ~200mb per user would remove ths problem) or do we have any other options you guys can think of to control this. The VMs have about 100gb hard drives, but we have around 50 users across these machines so tend to build the cache's pretty quickly.

 

We're getting into positions where we run out of space and lose a few hours while our IT teams manually login to the VMs and delete the cache from the users local app data folders.

 

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Data Cache size in PowerBI desktop

Hi  @MrShanktastic ,

I also not found effective suggestion to reduce data cache issues, maybe you can submit an idea for add option about 'auto clear up cache data every time your close power bi desktop'.

In addition, you can also try to write a batch script to trace power bi desktop status and clean up cache folder files.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Data Cache size in PowerBI desktop

Hi  @MrShanktastic ,

I also not found effective suggestion to reduce data cache issues, maybe you can submit an idea for add option about 'auto clear up cache data every time your close power bi desktop'.

In addition, you can also try to write a batch script to trace power bi desktop status and clean up cache folder files.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors