Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
According to this:
https://powerbi.microsoft.com/en-us/pricing/
Live connections are only supported with Pro license.
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.
Reference:
Databases in the cloud
Best Regards,
Qiuyun Yu
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |