cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jmccoy
Helper II
Helper II

Refresh and display every 5 min

I am putting into visuals the health of our servers for my developer to monitor without having to look through tables in SQL. The table in sql is set to pull in data every 5 minutes and update the table, this willl not be showing historical data. 

 

I  am using Microsoft SQL and I have a pro license for PowerBi. What I am looking to do is have this Power BI report update every 5 min and display the updated information that quickly. Currently with all of my reports being displayed. I am using a digital signage that only updates every hour. 

 

THis is a new avenue I am going down so I am not sure on the best option to achieve this. 

2 ACCEPTED SOLUTIONS
Icey
Community Support
Community Support

Hi @Jmccoy ,

 

When you use Direct Query option to connect to SQL Server, you could try to set Automatic Page Refresh.

Please pay attention to the minimum refresh interval:

Storage mode Dedicated capacity Shared capacity
DirectQuery Supported: Yes
Minimum refresh interval: 1 second
Capacity admin override: Yes
Supported: Yes
Minimum refresh interval: 30 minutes
Capacity admin override: No
Import Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Mixed mode (DirectQuery + other data sources) Supported: Yes
Minimum refresh interval: 1 second
Capacity admin override: Yes
Supported: Yes
Minimum refresh interval: 30 minutes
Capacity admin override: No
Live connect AS Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Live connect PBI Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A

 

If the report is in a Premium workspace / Dedicated capacity, you can refresh report page every 5 minutes.

 

If not, try to use Auto Refresh PowerBI Report extension.

unnamed.jpg

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @Jmccoy,

 

In addition to what @nickyvv explained, I'd look at a browser extension to automatically update your browser window for an unattended machine. This blog lists a few options for different browsers.

 

The automatic page refresh @Icey mentioned, will only work with Dedicated Capacity. I couldn't deduce from your explanation if this is the case. 

View solution in original post

4 REPLIES 4
Icey
Community Support
Community Support

Hi @Jmccoy ,

 

Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.

 


Best Regards,
Icey

Icey
Community Support
Community Support

Hi @Jmccoy ,

 

When you use Direct Query option to connect to SQL Server, you could try to set Automatic Page Refresh.

Please pay attention to the minimum refresh interval:

Storage mode Dedicated capacity Shared capacity
DirectQuery Supported: Yes
Minimum refresh interval: 1 second
Capacity admin override: Yes
Supported: Yes
Minimum refresh interval: 30 minutes
Capacity admin override: No
Import Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Mixed mode (DirectQuery + other data sources) Supported: Yes
Minimum refresh interval: 1 second
Capacity admin override: Yes
Supported: Yes
Minimum refresh interval: 30 minutes
Capacity admin override: No
Live connect AS Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Live connect PBI Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A

 

If the report is in a Premium workspace / Dedicated capacity, you can refresh report page every 5 minutes.

 

If not, try to use Auto Refresh PowerBI Report extension.

unnamed.jpg

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

nickyvv
Super User I
Super User I

If you use the DirectQuery option to connect to the table in SQL (where new data is imported every 5 min), the developer will always have the latest view on the data. DirectQuery will not import any data into Power BI, instead it will fire a query at the source database whenever a report or dashboard is opened.
There are a few limitation, so please have a look at: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Hi @Jmccoy,

 

In addition to what @nickyvv explained, I'd look at a browser extension to automatically update your browser window for an unattended machine. This blog lists a few options for different browsers.

 

The automatic page refresh @Icey mentioned, will only work with Dedicated Capacity. I couldn't deduce from your explanation if this is the case. 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors