Reply
Dasha
Frequent Visitor
Partially syndicated - Outbound

Buttons

Can we have more function on buttons? 
- Custom Python/R scripts run when clicked.
- Mulitple actions on click.
- Integrate Power automate flow as a button action to be used in conjunction with multiple actions on click.

4 REPLIES 4
christinepayton
Super User
Super User

Syndicated - Outbound

The Power Automate visual in Power BI will do multiple actions on a click if you put multiple actions as steps in the flow. 

 

Scripts I think you could potentially do with the Power Automate button as well, where you pass your data from the PBI report to Power Automate, and then have that run a Power Automate Desktop flow while also passing it the data... PA cloud can run PA desktop flows if you have a gateway and VM set up for it, and Power Automate Desktop has actions to run all sorts of scripts. It's a lot of hoop-jumping to set up though and can get expensive. 

Syndicated - Outbound

Yeah, That's right. 
Dual or mnulti functionality doesnt support backwards writing on the P/A visual though, so you're limited to P/A multi functionality, and can't do things like change page, or go to a bookmark ETC... 

Example use Case 

Clicks a button to navigate to a "Hidden report page" 
This also triggers a P/A script to write to a data log excel file
and the P/A script also Emails an I.T Admin 

It'd be great if P/A visual was integrated into the standard button visual and dual functionality was supported. 
- Also if you could backwards write python scripts to perform tasks like changing the language of the report/colors etc etc

Syndicated - Outbound

Yeah, that would be kind of cool. My guess is it's a security risk, being able to insert scripts in things in M365 is pretty locked down - e.g. you can't do it in SharePoint pages anymore either. I do wish there were more specifics logged in the audit log though, I don't think it goes down to the page level in the API. 

djurecicK2
Super User
Super User

Syndicated - Outbound

https://ideas.fabric.microsoft.com/  is the best place to request these or see if there is an existing idea.

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)