Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Download in background disabled, but it does it anyway - why?

I have a model that combines CSVs from a couple of SharePoint folders, grabs data from about ten SharePoint Lists and pulls a half a dozen excel files.  The data only needs to be refreshed once a month but I am constantly working on measures and visualizations.

 

I have disabled background data refresh, but very often when I open the .pbix my system slows to a crawl because Power Query has decided to refresh itself (I open the query editor and see several queries with the yellow caution next to them).  There are three Mashup processes churning away.  I have 6 cores, 24 gig of memory and allow 8 gig of cache to this model.  It takes 30 minutes or more and it consumes so many resources that skype becomes unusable.  As soon as the refreshes complete, all is back to normal.  I let it complete last night and then saved the file hoping it would quiet down for a while, but it did it again as soon as I opened it this morning.

 

Any idea why this is happening and how to stop that it so that it only resheshes when I ask it to?

 

image.png

 

image.png

 

image.png

 
1 ACCEPTED SOLUTION

Hi , @Anonymous 

For the issue,I have not come up with other workarounds.

It is suggest to raise it to the support team for better advice,please kindly open a ticket here if you are a pro user: https://powerbi.microsoft.com/en-us/support/

Support Ticket.gif

 

Best Regards,
Community Support Team _ Eason

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

I eventually worked around this issue by changing the logic in some of my queries.  I had been doing a Table.Buffer on a couple of tables that had grown pretty large.  Oddly, there was not a gradual degredation in performance as these tables grew over time, but rather I seemed to hit a wall.  Once I coded around the need for the Table.Buffer, the issue disappeared.  Still odd to me that this happened and the cache was not depleated.

v-easonf-msft
Community Support
Community Support

Hi , @Anonymous 

Make sure you have enough data cache space in your settings

03.png

04.png

 

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

Anonymous
Not applicable

@v-easonf-msft, thanks, but I suspect that is not it.  I have 8Gb allocated and it is using just over 1Gb.

 

Any other ideas?

1 Gb cache used of 8Gb1 Gb cache used of 8Gb

Hi , @Anonymous 

Take a try to  disable this:

05.png

 

 

 

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

Anonymous
Not applicable

Thanks @v-easonf-msft, but I do use that feature for data sources that almost NEVER change, but I need it enabled for those that as necessary for my monthly updates.

 

Are there any suggestions on how to troubleshoot this?  It has become a serious problem for me.

Hi , @Anonymous 

For the issue,I have not come up with other workarounds.

It is suggest to raise it to the support team for better advice,please kindly open a ticket here if you are a pro user: https://powerbi.microsoft.com/en-us/support/

Support Ticket.gif

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.