Power BI refresh failure notifications for the whole team
A Power BI semantic model failed to refresh overnight, and the only person who got the email was its owner, who is on holiday. You want the failure in a Teams channel, to the whole team, and also want to hear about refreshes that ran late or didn't run at all. Power BI's own notifications cover part of that; the rest needs the refresh history.
What Power BI sends on its own
Microsoft's documentation (Data refresh in Power BI, 2026) describes the built-in notifications:
- A failed scheduled refresh emails the semantic model's owner by default. In the model's refresh settings you can add other people under the failure-notification contacts, for example colleagues or a team alias.
- Those contacts must have accounts in your own Microsoft Entra tenant. External addresses aren't supported, which is why a Teams channel's email address doesn't work there (a common complaint on the Power BI Community).
- Only scheduled refreshes send these emails. A refresh started by hand, through the API or from Power Automate sends none.
- The emails are about failures. There is no built-in message when a refresh runs much later than planned or doesn't happen at all.
The last point matters more than it seems. Microsoft's page on scheduled refresh says a refresh may start up to an hour after its slot, that the schedule is turned off after four consecutive failures, and that refresh is paused after two months without report views. In the last two cases the refreshes simply stop, and the report shows older and older data.
Teams has also changed: the Office 365 connectors (the old incoming webhooks) were retired in May 2026. Alerts into a channel now go through a Workflows webhook.
Watch the refresh history with TaskBeacon
TaskBeacon's Power BI integration reads each watched model's refresh history with a service principal (an app registration in your tenant with read access to the workspace). No code runs on your side. Each model becomes a job:
- A Failed refresh becomes a Failed run with Power BI's error code, such as
ModelRefreshFailed_CredentialsNotSpecified. - The model's refresh schedule becomes the job's schedule, so a refresh that didn't happen shows as Missed, including after Power BI turned the schedule off.
- A refresh that takes much longer than usual shows as Late while it is still running.
The alerts go wherever your other alerts go: email to the job's extra addresses (each confirms once; they don't have to be in your tenant), Slack, a Teams channel through a Workflows webhook, Discord, Google Chat, ntfy or a webhook. On-demand refreshes are read from the same history, so they are covered too.
The setup takes an administrator once: an app registration, the tenant setting that lets service principals use the APIs, and Contributor access to each workspace (reading refresh history needs it). The Power BI page in the Docs lists every step. Integrations are part of Pro, open to everyone for now, and this one is marked beta: not yet run on a real installation — tell us how it went.
Without TaskBeacon
Add your colleagues or a mail-enabled group from your tenant as failure contacts in each model's settings; that covers failed scheduled refreshes for people inside the organisation. For a Teams channel, a Power Automate flow can watch the inbox that receives the failure email and post to the channel, or a scheduled flow can call the Power BI REST API's refresh history and post when the last refresh failed or is too old. The second also catches missing refreshes, at the cost of a flow per model or some looping logic, and an HTTP connector that may need a premium licence. See also data freshness checks for the data behind the model.
Connected Claude or ChatGPT to TaskBeacon? Ask it "what failed last night, and why?" and it answers from your jobs. How that works.
Related
In the Docs: Power BI refreshes · Integrations · Alerts in Microsoft Teams.
- Get an alert when a file doesn't arrive in SharePoint by 8:00Triggers fire when a file arrives; nothing fires when it doesn't.
- dbt Cloud job failure alerts, and runs that never starteddbt notifies about runs; a run that never started sends nothing.
- Check that a daily table or file is freshA load that "works" but brings yesterday's data again.
TaskBeacon is free to start, with every feature open for now and no credit card. Create a job, paste the code, and the first ping shows up on the job page.
Start free View live demoSources
- Microsoft Learn: Data refresh in Power BI (failure notifications, contacts in your tenant) (2026-09-18)
- Microsoft Learn: Configure scheduled refresh (start up to an hour late, disabled after 4 failures, paused after 2 months) (updated 2026-05-06)
- Microsoft 365 Developer Blog: Retirement of Office 365 connectors within Microsoft Teams (2024-07-03, updated 2026-04-14)
- Power BI Community: Can't set a Teams channel email address in a data set's failure notification (about 2023 (estimated))
Page checked against its sources on 2026-11-09. Menus and limits of other products change; if something here no longer matches, write to support@taskbeacon.io.