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...
sahilpruthi's avatar
sahilpruthi
Helper I
9 years ago

I am using Power BI pro and created a live connection with my database. After publishing the report, when I moved cursor on dataset it is showing "This dataset connects to a source with DirectQuery, which is always up to date. You don't need to schedule a refresh on this dataset".

 

But when i made a change in the database, it doesn't get reflected in the dashboard. What needs to be done to make the dashboard live.

 

Thanks in Advance.

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