Forum Discussion
Help with Power BI Subscriptions "After data refresh (once daily)" only running after manual refresh
Hello! I have a subscription email to be sent out from a Power Bi report after daily refresh. It missed some days and after investigation it seems it only runs after manual refreshes. It does not count teh regualr autimatic refreshes as valid triggers. Is there any way to change this configuration? Here is an example:
The email was sent on 7/10 but not on 7/11
This image shows the manual refreshes:
While this one shows the automatics refreshes
Hi jesualli ,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks for the detailed explanation.
Based on your follow-up, it’s clear that the automatic refresh is happening correctly (like at 9:47 AM PST), so the issue is not with the timing or time zone. What might be causing the problem is that your dataset is part of a semantic model deployed in a Fabric workspace, possibly using Direct Lake or pipeline-based refresh.
In such cases, the refresh might not show up in the usual “Refresh History” pane, and because of that, the native Power BI subscription (which depends on that log) doesn’t get triggered. A simple and reliable workaround is to use a Power BI dashboard just pin a visual to it, set a data alert, and then create a Power Automate flow to send the report by email after the alert triggers.
This way, the email gets sent even after an automatic refresh, without depending on manual refreshes. You can also explore modifying your pipeline to include a manual refresh activity and then call Power Automate from there.
Please let me know if you have any questions.
Thank you.
Tejaswi.
8 Replies
jesualli Something seems off there. The Refresh history should show both manual and automatic refreshes but your refresh history is only showing On demand (manual) refreshes.
Greg_Deckler Yep, I am not totally sure ehy. The "Refreshed" time on the model's home page has the latest auto refresh time, but when u expand teh display it only show sthe manual displays
I thought the same thing but from the first image and some subsequent checks it looks like auto refreshes happened 9:47 pst and even if it was utc it would still be 2AM that day but the email is not being sent at all on days there are not manula refreshes.
Hi jesualli ,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks for the detailed explanation.
Based on your follow-up, it’s clear that the automatic refresh is happening correctly (like at 9:47 AM PST), so the issue is not with the timing or time zone. What might be causing the problem is that your dataset is part of a semantic model deployed in a Fabric workspace, possibly using Direct Lake or pipeline-based refresh.
In such cases, the refresh might not show up in the usual “Refresh History” pane, and because of that, the native Power BI subscription (which depends on that log) doesn’t get triggered. A simple and reliable workaround is to use a Power BI dashboard just pin a visual to it, set a data alert, and then create a Power Automate flow to send the report by email after the alert triggers.
This way, the email gets sent even after an automatic refresh, without depending on manual refreshes. You can also explore modifying your pipeline to include a manual refresh activity and then call Power Automate from there.
Please let me know if you have any questions.
Thank you.
Tejaswi.
