Curious, SharePoint List-like JSON buttons in table visual to run automations

Hii apangeles 

Power BI does not support SharePoint-style JSON formatting to create clickable buttons inside table visuals. JSON column formatting is a SharePoint List feature, not available in Power BI visuals. In Power BI, automations can only be triggered using supported options such as the Power Automate visual, buttons (with Power Automate or URL actions), or drill-through / URL links. You cannot embed JSON-defined buttons directly in a table cell to run flows, even for internal reports.

Hi apangeles  - In power bi does not support SharePoint-style json buttons or inline flow triggers. 

PS: cannot replicate the same as like sharepoint buttn json.

Hi apangeles ,

You have received correct information from the community: The JSON formatting syntax used in SharePoint Lists is specific to the SharePoint UI rendering engine. Power BI table visuals do not support this syntax, so you cannot embed a native "Action Button" directly inside a table cell using JSON.

However, since you need this for internal use to run automations, there are two standard ways to achieve this functionality in Power BI:

1. The "Official" Way: Power Automate Visual Instead of a button in every row, you use a context-aware button next to your table.

• How it works: You import the Power Automate for Power BI visual.

• The Workflow: The user selects a row in your standard Table visual (which cross-filters the Power Automate button), and then clicks the "Run Flow" button.

• Pros: It is secure, integrated, and allows you to pass specific data fields from the selected row directly to the flow.

2. The "Row-Level" Way: HTTP URL Triggers If you absolutely need a clickable icon inside every row of the table, you can use a Web URL.

• How it works:

  1. Create a Power Automate flow with an "When an HTTP request is received" trigger.

  2. Create a DAX measure that constructs a URL with parameters: "https://prod-flow-url...?id=" & SELECTEDVALUE('Table'[ID])

  3. In your Table visual, mark this measure's Data Category as Web URL.

  4. Enable URL Icon in the visual settings.

• The Experience: The user sees a link icon in every row. Clicking it triggers the flow via the browser.

• Cons: This will open a new browser tab/window every time it is clicked, which is not as clean as the SharePoint experience.

Recommendation: Stick with Option 1 (Power Automate Visual). It requires an extra click (Select Row -> Click Button), but it provides the native experience you are looking for without opening browser windows.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.

No, Power BI table/matrix visuals don’t support SharePoint-style JSON column formatting (custom buttons/links/actions defined by JSON).

What you can do in Power BI instead:

• Power Automate visual: add it to the report, pass selected row values (e.g., ID) into a flow, and let users trigger the automation from the report. This is the closest “run flow from a row” experience.

• Button / shape + Power Automate: use a button to trigger a flow (still relies on user selection in the report, not per-cell JSON formatting).

Hi apangeles,

I would also take a moment to thank cengizhanarslan ,  burakkaragoz, rajendraongole1, rohit1991 for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

apangeles Hey,

You can’t use SharePoint’s JSON column-formatting approach in Power BI. Power BI doesn’t support JSON-based button rendering or per-cell action JSON like SharePoint lists.

Microsoft-supported ways to trigger Power Automate from Power BI:

• Power Automate visual (recommended, certified)

- Add the “Power Automate for Power BI” visual.
- Drag fields you want to pass (selection context) into the Data buckets.
- Click “Create flow” in the visual → uses the “Power BI button clicked” trigger.
- Build your flow steps (e.g., create SharePoint item, send Teams message).
- Publish; users click the button in the Service to run the flow with current filter/row context.
- Notes: Runs only in Power BI Service (not Desktop). Users need permission to run the flow; premium connectors require appropriate Power Automate licensing.

• Power Apps visual

- Embed a small Power App with buttons; the app can call flows. More UI flexibility but heavier setup.

• URL/action workaround

Thanks

Haish K 

If I resolve your issue. Kindly give kudos to this post and accept it as a solution so other can refer this