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

Report refresh upon dataset refresh

I currently have a report created using data from a mySQL server. This report has slicers and a timeline so that others in my organization can filter the data. Currently, I can schedule dataset refreshes, but the report itself doesn't update unless I manually update it. I know that pinning visual to a dashboard will update them automatically when the dataset is updated, but because there are slicers/timelines, having a pinned visual doesn't allow the user to interact with the report. Is there anyway to have the report update when the dataset is refreshed?

1 ACCEPTED SOLUTION
Super User III
Super User III

You have a couple of options - mainly related to changing the data source to Direct Query mode. That would make the scheduled refresh obsolete, and would also allow you to set up auto page refresh for individual pages.

 

If for some reason you need to keep your scheduled refresh then user education is the only way (mostly teaching them how to press F5 in their browser)

 

 

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

Hi @lauka ,

If you want to keep slicer's interaction , you could pin a live page to dashboard.

 

Hope these help.

https://community.powerbi.com/t5/Service/Auto-refresh-for-dashboard-and-report/td-p/1340042

https://community.powerbi.com/t5/Service/Report-visuals-not-updating/td-p/176645

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

Super User III
Super User III

You have a couple of options - mainly related to changing the data source to Direct Query mode. That would make the scheduled refresh obsolete, and would also allow you to set up auto page refresh for individual pages.

 

If for some reason you need to keep your scheduled refresh then user education is the only way (mostly teaching them how to press F5 in their browser)

 

 

View solution in original post

My database is a mySQL server, so Direct Query isn't supported. I hadn't realized that embedded reports are refreshed upon opening though, so actually I don't think it's too much of a problem anymore.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors