Forum Discussion
Helper IMy Visuals in Report does not refresh after Sematic model refresh
Hi, I have problem about Visuals not refresh on Power BI service.
My use case: I need to send an email to users everyday via subscription.
What I Do now:
- Published report to Power BI Service
- Set schdual on sematic model <-- This refresh successfully everyday (5 AM)
- Add user for subscription after sematic model refresh (7 AM)
I already clear chach and include in report refresh
My Problem:
- When the email is send, the visual data is not update. I need to be back in power bi service and update vai refresh button manully and the visual will be updated
Anyone know how to slove this problem?
Thank you !
Hi Mokegubshook ,
Thanks for checking on those points, and you're right Power Automate’s built-in Power BI connector only supports dataset refresh, not direct report visual refresh.However, there’s a solid workaround using the Power BI REST API via the “Export to File for Power BI Reports” action. This process forces the report to render freshly, which effectively updates the visuals. Please refer following Official documentation: Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
7 Replies
Hi Mokegubshook,
We are grateful for your participation in the Microsoft Fabric Community forum.
1. Make sure the dataset refresh at 5 AM is fully done before the subscription email goes out at 7 AM. Check the refresh history in Power BI Service to confirm.
2. Subscriptions use the default filter and slicer settings from the report. If you’ve made changes after setting up the subscription, update the report defaults so they match what you want users to see.
3. Power BI caches report visuals separately from the dataset refresh, which can cause outdated visuals in emails. Turn on Scheduled Cache Refresh in the report settings to keep everything in sync.
4. If the report cache takes some time to update, try pushing the subscription email to 7:30 AM instead of 7 AM to give it a little extra time.
5. Power BI doesn’t refresh report visuals automatically after a dataset refresh. Use Power Automate’s Power BI Connector to trigger a report refresh before sending the email.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks,
Priyanka.
MokegubshookThank you for respond,
For 1 - 4 I already check on it but still don't work. Do you know what connector for Power Automate’s Power BI Connector should I use for power automate. I don't see any I only see refresh Data set Not refresh visual in report
- Mokegubshook
Thank you for respond,
For 1 - 4 I already check on it but still don't work. Do you know what connector for Power Automate’s Power BI Connector should I use for power automate. I don't see any I only see refresh Data set Not refresh visual in report
Hi Mokegubshook ,
Thanks for checking on those points, and you're right Power Automate’s built-in Power BI connector only supports dataset refresh, not direct report visual refresh.However, there’s a solid workaround using the Power BI REST API via the “Export to File for Power BI Reports” action. This process forces the report to render freshly, which effectively updates the visuals. Please refer following Official documentation: Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.