Help with Power BI Subscriptions "After data refresh (once daily)" only running after manual refresh

[jesualli]

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

[GilbertQ]

Hi @jesualli 

Could it potentially be that the refresh is happening before midnight UTC? I do know that all the power, BI servers are in UTC so potentially that is why it is happening.

[jesualli]

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.

[v-tejrama · Accepted solution]

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.

[v-tejrama]

Hi @jesualli ,

Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.

Thank you.

[v-tejrama]

Hi @jesualli ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[v-tejrama]

Hi @jesualli ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

[Greg_Deckler]

@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.

[jesualli]

@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