Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Automatic PowerBI report refresh

Hello,   we've faced a major issue with Power BI reports.   Our client has some reports online that are connected with a live connection to their on-premise SSAS cube (currently Multi-Dimensional...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

According to this article, If your dataset is configured for a live or DirectQuery connection, datasets are refreshed approximately each hour or when interaction with the data occurs. You can manually adjust the refresh frequency in the Scheduled cache refresh option in the Power BI service.

when interaction with the data occurs means something like create a visual and add data into or filter data, not refer to open a report.

If you want to created a real-time dashboard, you can take a look at below articles:

Real-time streaming in Power BI (Preview)

 

Reference:

Data refresh in Power BI

 

Best Regards

Maggie

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-juanli-msft,

 

thanks for your answer.

 

However, it doesn't exactly solve my problem. 

 

Refresh frequency is now set to 15 minutes. If you imagine a case when the cube gets processed in the range of 9:10 AM to 9:25AM. In the best case, users can see the results (when they open the report) instantly. In the worst case, they have to wait the whole 15 minutes to get fresh data shown to them. 

I can't achieve instant fresh data shown on the report in Power BI, can I? That's a major setback. 

Is it possible to disable caching for one report?

Best regards, Boris

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear Maggie,

       

      it seems to me that you didn't read the whole post where I was describing my problem.

       

      Our reports are connected via "live connection", not "direct query".

       

      And the whole issue is that the client(s) refuse(s) to use the "refresh button", as they expect the reports to be "fresh" when they open the report. The only issue here is the "user experience".


      Best regards,

      Boris

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Dear Maggie,

         

        it seems to me that you didn't read the whole post where I was describing my problem.

         

        Our reports are connected via "live connection", not "direct query".

         

        And the whole issue is that the client(s) refuse(s) to use the "refresh button", as they expect the reports to be "fresh" when they open themt. The only issue here is user experience.


        Best regards,

        Boris