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 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.

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

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    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
        Icon for Microsoft Employee rankMicrosoft 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