Exploring the Power Automate Visual in Power BI | Sending emails

Using Power Automate? Using Power BI? Why not put the two together for some interesting scenarios. Patrick uses the Power Automate visual, in a Power BI report, to send emails out.

Power Automate:

Blog Announcement:

Documentation:


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #PowerAutomate #GuyInACube

[flchange]

Hey Guys... Ever considered to make a series of "Guy in a Flow" featuring Power Automate stuff? I would be your first and most appreciating customer!

[morganmcgary]

Every time I watch one of your PowerBI videos Patrick my brain explodes with new capabilities. This is just in time for a report I’m working on.

[varuntiwari]

Hey Patrick, that's preety awesome.
I liked the thought and it really make sense to have it in a business report.
Thanks for featuring it.🎉

[Nerosis]

Neat stuff! This opens up new options for me. I've used Power Automate to send exported PPT versions of BI reports.

[atifmir]

Top video. Didnt know we could integrate Power Automate with Power BI until I watched this vid. Many thanks.

[ganeshkodam]

This was awesome brother. Thanks a lot for such a lovely content.

[RhondaNewman-whwv]

Love this!! Clearly I have been living under a rock somewhere. Thank you!

[sushichef]

Thank you. You answered my question in less than 60 seconds

[gabriellamercuur]

Great video, Patrick. Can you explain/make a video on how you would implement Power Automate flow within an embedded Power BI Report? How can you enable external users of the embedded report to trigger the flow? When you don't know their email address?

[prachigorwadkar]

Amazing & super simply explained video..

[reaperqnu]

Thanks for the instructions. Can we somehow automate the process without using a trigger button and instead trigger it whenever the BI report is refreshed? Seems not quite 'automated' to me if we need to click a button every time to get the data sent.

[kh]

So many possible uses for triggering actions via PowerAutomate beyond just sending emails. Thank you for sharing, this opens up tons of possibilities!

[RobIvy]

This is amazing. So many applications. Is there any way for the run permissions for the flow to be inherited from the list of authorized users of the report?

[aerobrain]

I love this new visual, currently setting up a report that people can use it for to pre-populate some people review forms. I just wish the permissions for running the flow could be a bit smarter. I'd ideally love to be able to either give access to run it to everyone in my organisation and/or everyone who has access to the report. Just a slight pain that I'll have to manage another security list for something that is only ever going to be embedded in a report that I already control access to anyway.

As you say, I'm not lazy, just efficient lol

[fitches]

Great vid, but how might you add the values in the table of data? It doesn't seem to be available to select in the dynamic list.

[rajarshisingh]

It solves two problems of my customer instantly. I was to create a new report but now I think using this I need not to do that. Thanks Patrick great stuff

[topher]

Please do more videos on creative ways to use this awesome feature!

[timgray]

Thanks for another great video Patrick! Can you do a video regarding Direct Query to DataFlows? Currently using import mode using Power Automate to sync the refreshes. I'm wondering about the performance of the DAX queries using Direct Query compared to Import mode to a dataflow in the service.

[jhewitthunt]

fan dabby bleedin dozy! love this Patrick. Very simple when you explain it that well. Thanks!

hi this is awesome! do you happen to know if exporting a summarized table/data can be sent via email as an attachment? is this possible?