Forum Discussion

More_BI's avatar
More_BI
Frequent Visitor
9 years ago
Solved

Having trouble with refresh failures

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 back...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    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's avatar
More_BI
Frequent Visitor
9 years ago

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's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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