Use Power Automate to send Power BI alerts

[@sangharshaggarwal]

Very nice exception reporting

[@AccessAnalytic]

Thanks

[@marshal115]

Nice tips! I think you can also write the code using CALCULATABLE too Number of Units Missing = COUNTROWS( CALCULATETABLE( VALUES( ShippingData[Item Code] ), ISBLANK( ItemTable[Item Code] ) ) ) and then use the same logic to pull the list of missing items. Cheers

[@AccessAnalytic]

Yep nice one

[@mirrrvelll5164]

Great videos as usually! This operation violates the admin data policy "XYZ Default DLP" which restricts the use of business connector "shared_powerbi" with non-business connector "shared_sendmail". Do you know why this occurs? I tried this approach in my company but sends me some violation policy things...

[@AccessAnalytic]

Sounds like some data protection policy setting controlled by your IT admin

[@fltnbi9893]

Thank you, Amazing!!

[@AccessAnalytic]

You're welcome

[@wayneedmondson1065]

Hi Wyn. Awesome tutorial! Thanks for illustrating this problem and solution. Very helpful :)) Thumbs up!!

[@AccessAnalytic]

Cheers Wayne, lots of elements to consider here

[@bigdaddy5621]

Extraordinary. A perfect and easy way for a process i have been looking for. Amazing job, many thanks!

[@AccessAnalytic]

You're welcome, thanks for the kind comment

[@IvanCortinas_ES]

As interesting, powerful and practical as ever. Thank you for this video Wyn!!

[@AccessAnalytic]

No worries, thanks Iván

[@bristobalpy]

Is there a way to send the user to the report instead of the tile? So they do not have to press the "Go to report" button?

[@AccessAnalytic]

Hi, yes you could put a URL link to the report in the notification step around the 10 minute mark

[@mohammed333suliman]

Aha I like it, I'm gonna use it for my reports

[@AccessAnalytic]

That's great Mohammed

[@trompe8]

I ve been using this technique for a while, is great. In your example, Is there a way to send "C,D" in the notification? Or maybe in an email ?

[@AccessAnalytic]

I'm not sure Mario, I would have thought you could put the contents into the body of the email

[@stflytics2371]

Hi Wyn, thanks for your great content!

[@AccessAnalytic]

You’re welcome

[@henrifanda4784]

this method is not valid anymore with the introduction of Fabrics

[@AccessAnalytic]

Which bit doesn’t work?