Having trouble with refresh failures

[More_BI]

Hi all,

I'm not sure if this is a bug, a setting, or user error... When I'm working on my queries, sometimes a change will cause some previews to break and need to be refreshed. I turned off background refresh because my files are getting large (~500mb+) and I can't stand waiting 10-60s+ for a preview refresh between actions. 

Anyway, I had thought that if I clicked refresh all at the top (in query editor) that it would refresh all previews, but this is not the case. I have to manually click on each query to load the preview.

I also thought that a file refresh would have gone through refreshing everything, but I end up getting failures saying it failed to load a previous table. I have to manually go into my queries and refresh each one individually before refresh will work. Any thoughts?

FWIW, I am on the latest build of Power BI.

[v-jiascu-msft · Accepted solution]

Hi @More_BI,

It works fine in my test. To be honest, I had such experience. Could you please check the following.

1. How much space left in the Data cache area?

2. Maybe there is a workaround. Remember the name of the failed table, go to Query Editor, uncheck "include in report refresh". Then refresh would go right. Finally, we can refresh the failed table manually.

Best Regards!

Dale

[More_BI]

Ah, that is insightful, thank you.

I am using 3.33gb/4096mb. 

Is the cache memory or HD? Is there any harm in increasing the cache or clearing it? What is stored on the cache?

I should have enough system resources to increase the cache size though.

[v-jiascu-msft]

Hi @More_BI,

The cache is in the HD. The default size is 4096M. The cache is good for speed while sometimes it's the cause of a problem. The cache is the copies of query preview. I think the default setting is good enough.

Best Regards!

Dale