Forum Discussion

sahilpruthi's avatar
sahilpruthi
Helper I
9 years ago

desktop

I have created a DirectQuery connection with SQL Azure Database. I am using Power BI (free) for this. I want to confirm whether any change in my database automatically refreshes the reports/dashboar...
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi sahilpruthi,

 

As you are connecting to Azure SQL database in DirectQuery mode, when you interact with a visualization, queries are sent from Power BI directly to the database. Updated data is then returned and visualizations are updated. If there is no user interaction in a visualization, like in a dashboard, data is refreshed automatically about every fifteen minutes. You can also click "Refresh dashboard tiles" to get updated data in no time.  

 

 

Reference:
Databases in the cloud

 

Best Regards,
Qiuyun Yu

sahilpruthi's avatar
sahilpruthi
Helper I
9 years ago

Thanks

 

Is there any service(or any other thing) that updates my dashboard instantly after I made an update in the database.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi sahilpruthi,

     

    What I mentioned above happens in Power BI Service. When you interact with visual, you can always see the latest data.

     

    Best Regards,

    Qiuyun Yu