Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Post Power BI Refresh Failure Notification to Teams channel

I've seen some older posts on this, but can't find anything recent. Has anyone been able to make Power Automate talk directly to Power BI to post refresh failure notifications to Teams rather than sending an email? If not, any workarounds more elegant than setting up a contact in AD for the Teams channel email?

Responsive Resident
Responsive Resident

Hello - this is how I have done it within Power Automate.  This flow is triggered by 'when a dataflow refresh completes', if successful, the downstream dataset is refreshed, if unsuccessful, a failure alert is posted in a Teams message.


After the flow is triggered, I compose some values to use in the Teams message.  Then create the conditional outcome.






Here is a bigger snip of the message action.  Placing text inside ** appears as bold, and single * creates bullets in the message.



Here what the message looks like when received in Teams.




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors