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

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.