cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smileamile2
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?

1 REPLY 1
jennratten
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.

 

jennratten_1-1633900573830.png

 

jennratten_3-1633900619515.png

 

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

jennratten_0-1633900483942.png

 

Here what the message looks like when received in Teams.

 

jennratten_4-1633900787715.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors