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, not Tabular) on SQL Server 2016.

 

We refresh the cube twice a day (it's finished at approximately 18:45 CET an 09:45 CET). When the end-user logins to PBI online at 9:50 CET and opens a report, we would expect that he would see the latest data (refreshed at 09:45 CET), but this isn't the case.

 

It is not acceptable for them to wait another 15 minutes for the data to refresh (and I'm not even sure that this works). This is a major deal-braker for lots of our other customers, and we won't be able to use Power BI for them in the future, if we can't solve this issue.

 

How can we force Power BI to refresh reports at some point (with a web-service call after ETL process or something like that), or that the report automatically (without pressing the Refresh button) gets refreshed when the user opens the report?

 

Thank you in advance.

Need Help

6 Replies

  • 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