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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

2017 october update report server: Is it possible to automate Scheduled refresh?

Hi all,

 

Scheduled refresh functionality is given in Report server's October 2017 update. 

So in scheduled refresh tab I am able to set scheduled refresh plan for upto 1 minute. 

 

My Data Source type is MySQL.

I have set scheduled refresher for 1 min. So after 1 min I am able to get updated data form MySQL. 

But for this I need to click on Refresh Now button or on report I need to click on Refresh button. then and then only my data gets updated on all visuals.

 

So my question is it possible to automate this scheduler refresh activity?

Like whenever MySQL data gets refreshed after 1 min then automatically it gets reflected on all visuals without clicking on refresh button?

 

TIA.

 

Regars,

Shraddha

2 REPLIES 2
rpatkar
Power BI Team
Power BI Team

You can create a refresh schedule that will refresh the data every minute. Getting the visuals to update on an already open report will not happen automatically without clicking the refresh button the report or refreshing the page. If you need the visuals to get updated automatically, one option could be embed the power bi report page through an iframe in your custom html page and in your html page add a timer that refreshes the entire page periodically. To learn more about embed, please refer https://powerbi.microsoft.com/en-us/documentation/reportserver-developer-handbook-overview/

 

Anonymous
Not applicable

Hi @rpatkar

 

Thanks a lot for your valuable reply. Many of my issues gets resolved. 🙂

 

Regards,

Sharddha.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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