cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saivenkat Member
Member

Refresh report every 5 minutes or less

Hi All

I can set the report to refresh every 15 minutes, but is there a way to set it to refresh every 5 minutes or less?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
foxglove666 Regular Visitor
Regular Visitor

Re: Refresh report every 5 minutes or less

Hi @saivenkat 

 

As long as your report is built in Direct Query, everytime you load the report in your browser it will refresh the data so all you need to do is go into the options of Rotisserie and add the URL for your report, plus the number of seconds you want it to refresh. I have added multiple reports so they show in order and display different reports.

 

Screenshot_2.png

Screenshot_5.png

 

If you want to get rid of the BI user interface for displaying it then type

?chromeless=1

at the end of the URL.

 

I then connect this to a 60 inch plasma in my office to display stats in near real time.

 

I hope this helps.

7 REPLIES 7
Highlighted
Community Support Team
Community Support Team

Re: Refresh report every 5 minutes or less

HI @saivenkat ,

Nope, power bi not allow you to setting such small interval/frequency of schedule refresh. If you want to show live data, I'd like to suggest you to create streaming dataset and live tiles.

Real-time streaming in Power BI

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
saivenkat Member
Member

Re: Refresh report every 5 minutes or less

Thanks it is what it is .

foxglove666 Regular Visitor
Regular Visitor

Re: Refresh report every 5 minutes or less

Hi @saivenkat 

 

If you just want to see the data as a visual you can do something I have done. Create the report as a direct query and then display the report in Chrome with an extension which refreshes the page on an interval. (https://chrome.google.com/webstore/detail/rotisserie-url-rotator/iljemanjjfjlglhkmojkmfbpphiaheja?hl...)

 

I use this on some 60" plasma's around the office and switch between a few different reports every minute or so. This way you can see how the business is doing and keep updated in almost real-time.

 

Let me know if this helped.

saivenkat Member
Member

Re: Refresh report every 5 minutes or less

Thanks Foxglove i am doing it now and will update you.

Thanks

saivenkat Member
Member

Re: Refresh report every 5 minutes or less

Foxglove666 after adding the extension what am i supposed to can you please explain?

Thanks

foxglove666 Regular Visitor
Regular Visitor

Re: Refresh report every 5 minutes or less

Hi @saivenkat 

 

As long as your report is built in Direct Query, everytime you load the report in your browser it will refresh the data so all you need to do is go into the options of Rotisserie and add the URL for your report, plus the number of seconds you want it to refresh. I have added multiple reports so they show in order and display different reports.

 

Screenshot_2.png

Screenshot_5.png

 

If you want to get rid of the BI user interface for displaying it then type

?chromeless=1

at the end of the URL.

 

I then connect this to a 60 inch plasma in my office to display stats in near real time.

 

I hope this helps.

saivenkat Member
Member

Re: Refresh report every 5 minutes or less

Thank you so much. I have the exact same scenario and this work great , just a tad delay on the 65 inch screen, can live with that. :-)

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 244 members 2,876 guests
Please welcome our newest community members: