Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
sahilpruthi
Helper I
Helper I

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

 

Regards,

Sahil

7 REPLIES 7
Greg_Deckler
Super User
Super User

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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

According to this:

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

 

Live connections are only supported with Pro license.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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.

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.  

 

q5.PNG

 

Reference:
Databases in the cloud

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks

 

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

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.