Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

SujataNarayana

Announcing the new Power Automate visual for Power BI reports

Power Automate visual for Power BI (preview)

Empower your end-users to go from insight to action. With the new Power Automate visual, end-users can run an automated 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.

Microsoft_Business_Application_Summit_RecapMicrosoft_Business_Application_Summit_Recap

We hope you enjoy this new visual and greatly appreciate any feedback you'd like to share!

Continue reading for setup instructions and more details on the feature.

How does it work?

To get started, simply download the visual from AppSource and import it to your Power BI report. You're notice that the initial state of the visual contains getting started instructions.

Scroll down or resize the visual to see all the instructions.

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Once you've reviewed the information, you can resize the button and place it where you'd like on the report.

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Next, you will want to add any data fields to be used as dynamic inputs to the Flow: Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

In the More options menu (. . .) you will need to select the Edit option Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports to configure the button:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Once in the edit mode of the visual, you will need to select an existing Flow to apply to the button or create a new Flow to be applied to the button.

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

To create a new Flow, you can start from scratch Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports or start with one of the built-in templates as an example. We plan on adding more templates to future releases, so we really appreciate if you can include which templates or connectors interest you in our feedback form.

Here's an example for creating a Flow from scratch:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Once you select + New step, you can choose a subsequent action or specify a Control if you want to specify additional logic to determine the subsequent action. Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Optionally, you can reference the data field(s) as dynamic content if you want the Flow to be data contextual. In this example I'm using the Region data field to create an item in a SharePoint list. Based on the end-user's selection Region could have multiple values or just one.

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

After you've configured your Flow logic, you can name the Flow and click Save.

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Then you can click the arrow button to go to the Details page of the Flow you just created:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Details page:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Next simply hit Apply button Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports to attach the Flow you've created to your button.

Once you have applied a Flow to the button, we recommend testing the Flow first before you share the Flow with others. Note that you can only run these Power BI Flows in the context of a Power BI report. You cannot run these Flows in Power Automate web app or elsewhere.

If your Flow is data contextual, you will want to test how the filters selections in the report impact the Flow outcome.

To test the Flow in edit mode of the report, select Back to report,
and then hit Ctrl + click on the button to run the Flow in the context of the report.

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

The button text will indicate once the Flow has been triggered. However, to check if the Flow has run successfully, you will need to enter the edit mode of the visual and select Details within the More commands menu (. . .) of the Flow that has been triggered:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Once on the Details page, you will be able to see the run history and status for the Flow:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

If the Flow is running successfully, you can then share the Flow with your report readers. Select Edit in the Run only users section:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

And then specify which users or groups you want to give run access to:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Alternatively, if you want to give any users edit access to the Flow (not just run permissions), you can hit the Share option Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports and specify the users or groups that you want to add as an owner:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Optionally, if you want to change the Button
text, font color, font size, or fill color of the button, you can find these options along with other settings in the Format pane:

Announcing_the_new_Power_Automate_visual_for_Power_BI_reportsAnnouncing_the_new_Power_Automate_visual_for_Power_BI_reports

Limitations and considerations

  • For the full capabilities, such as automation of flows that do not need Power BI fields as inputs, the visual will require using the April 2021 release of Power BI, which will go live soon.
  • Manual, user-entered  inputs to the button are not supported at this time. We plan to add support for this by our General Availability release.
  • Currently, we only have a few built-in templates; however, we will be adding more based on user feedback.
  • The visual is not supported for PaaS embedded scenarios nor in Sovereign Cloud scenarios.