This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid 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
Microsoft_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.
Scroll down or resize the visual to see all the instructions.
Announcing_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_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_reports
In the More options menu (. . .) you will need to select the Edit option Announcing_the_new_Power_Automate_visual_for_Power_BI_reports to configure the button:
Announcing_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_reports
To create a new Flow, you can start from scratch Announcing_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_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_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_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_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_reports
Details page:
Announcing_the_new_Power_Automate_visual_for_Power_BI_reports
Next simply hit Apply button Announcing_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_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_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_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_reports
And then specify which users or groups you want to give run access to:
Announcing_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_reports and specify the users or groups that you want to add as an owner:
Announcing_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_reports
Limitations and considerations
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.