desktop

[sahilpruthi]

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/dashboards?

Regards,

Sahil

[Greg_Deckler]

Yes and no. Since you are using DirectQuery, you are querying the data live. So, there is no automatic refresh, each time you view the report/dashboard it is querying the database and coming back with the latest information.

[sahilpruthi]

I made some modifications in db but it doesnt reflect on dashboard.

[Greg_Deckler]

According to this:

https://powerbi.microsoft.com/en-us/pricing/

Live connections are only supported with Pro license.

[sahilpruthi]

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]

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]

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]

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