Power Automate visual for Power BI reports - run flow

Empower your end-users to go from insight to action using the new Power Automate visual for Power BI reports. With the new Power Automate visual, end-users can run an instant / button flow all within a Power BI report. Furthermore, the executed flow can be data contextual, meaning that the Flow inputs can be dynamic based on the filters set by the end-user in the Power BI report.

#PowerBI #PowerAutomate #flow

Table of Contents:
00:00 - Introduction
00:41 - Add Power Automate Visual to Power BI report
02:40 - Create flow based on Power BI templates. Send data to Teams.
05:30 - Run flow from Power BI
08:25 - Add formatting to Power Automate Visual
09:02 - Run flow to send Power BI Dataset to Outlook Tasks
11:22 - Run flow to send Power BI data to Microsoft Teams as an Adaptive Card
13:39 - Subscribe to Reza Dorrani Channel

[FranciscoCarniello]

Another excellent and useful tutorial from you Reza. Thanks a lot!

[robofski]

I use Power BI to manage my Power BI licenses and remove licenses from people who are not actually accessing anything in the service. All manually until this button! Now I can click a button and send a custom approval to the user asking if they still need their license, then depending on the option selected I can remove their license or add them to a list of users who requested to keep the license (then if a user appears on the keep list but still doesn't use it I can take other action later!)

[VroomGaur]

I continue to be amazed by your content Reza. I find each one of your video incredibly useful to solve user requirements at work.. No other content creator has such precise videos on solving actual practical problems. Thanks!

[sujisam]

Thank you so much Reza! I am learning so many new things in your videos. Please continue to share more videos 😀

[BiharKiShaan]

Awesome video. Thanks, Reza! Just Quick question. I have created a powerBi dashboard with power automate flow in it. Now, i have passed the dashboard to powerapps canvas screen. And now if I click on runflow, it didn’t trigger anything. I am sure because the flow first action was “On power Bi button clicked”. Can you help me how could I achieved this in my case

[fastjayneel]

Big fan of you Reza, Lots of love and blessings. Your videos have helped a lot in scaling up our skill sets.

[awimanu]

Once again you nailed it !!! You videos have helped me so much, thank you Reza!

[Ethan-ddln]

Excellent video, Reza. Thank you for the detailed new feature! Subscribed!

[arshad]

As always there is something new to learn..thanks Raza

[karukarthi]

Thanks Reza for this video. I keep following your videos and something new to learn as always 🙂 would like to hear more about from spfx & modern list customization as well.

[northernboy]

Amazing video, thank you! Very well demonstrated 😀

[SHAli]

You're like Google for PowerApps, I got a question you got a video :)
Thanks Reza.

[davidmorris]

Hi Reza,
are you aware of any reason why Power Automate flows will not trigger correctly from an embedded Power BI report on a Sharepoint page? My trigger works beautifully from Power BI Desktop and from Power BI web interface, however when clicking the button on the same report that is embedded on a Share page, the button text changes to "Triggering" and just sits there. Nothing else happens. Checking the 28-day run history of the flow shows it has not been triggered at all, therefore no errors thrown, just no initiation of the trigger at all.

Have you seen this same issue yourself? Have you been able to resolve it?

[Boomtiger]

Hello,
I perform a monthly financial analysis at work. This entails a lot of monotonous work, such as taking screenshots of visualizations in Power BI and manually copying and pasting data from our data models into an email. I then send this email out to whomever needs it.

Can Power Automate pull these visualizations exactly how I need them (filtering-wise) and type out the data for me? Ex: Rev YTD is $[enter the revenue YTD from the data model here]. I’m tired of having to type the same things over and over, and I make mistakes all the time lol

[VB-pkpp]

Hi Reza, its a great helpful video thank you.
Are you able to do a video to show how to copy a flow visual button to another page and edit the flow also how to add warning dialogue box to warn as the user click on the flow button

[lolalola]

Very good video! Do you how to export a report in PI using power automate but the report has a slicer with many filters? Can power automate filter the slicer?

[pkdomo]

Awesome video. 1 question. Can we implement PowerBI Automate in such a way that as soon as a new record gets inserted to a input table of the dataset, it will run the flow automatically & create task without any button click?

[hanishvaitla]

Hey Reza I have a powerapps form and with each submission, i have a power automate flow running. I want to visualize this in a table, such that all my form submissions have their corresponding flow runs beside. Is this possible ?

[samvithb]

Thanks Reza. I tried exporting 2300 rows. The visual is able to push only 1000 rows to CSV. Could you please help ?

[rhumeetsinus]

is there a way to make sure that the flow button can only be run by a user, or group of users? can we use RLS with this button? thanks