Unanswered

Power BI Power Automate button not passing data

(0) Share

Report

Posted on by KONeill102399

I am using Power Automate in a BI report to pass the selected date to a flow to generate a CSV file and email, but the data is not passing to the flow.

What happens:

User selects a FA# from Slicer
User select power automate button
Flow passes the FA# data to build CSV and draft email.

The flow runs as expected, but the input on the trigger is showing nothing in the JSON. It should be passing the FA# and other information (see below image). Actually, the flow was working but then I had to change something in my BI build and it stopped working. I know this can be an issue with power automate so I tried the below fix and nothing worked.

Recreated the power automate several times.
Limited the fields in the power automate button to 2
Saved BI file, closed it, open it back up, re-published it, and ran flow again.
Cleared out cache in web browsers.
Tested in both Edge and Chrome
Tested in desktop and service.

Categories:

Building flows

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pstork1 69,323 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you show how the button is setup in Power BI? It looks from the output like something is over filtering the output of the report. Are there any other page filters on the report?

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
lbendlin 8,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

In your Power BI report, duplicate the Power Automate visual and then convert that copy to a table visual. That will show you the payload that will be transported to Power Automate. Make sure what you see is what you expect.

Was this reply helpful? Yes No
11manish 1,271 on at

Like (0)

Report
Copy link

Link copied!

It seems that the issue is caused by broken field binding between the Power BI Power Automate visual and the flow trigger. Even though the flow runs, no data is passed because the visual is not correctly mapped to the selected fields. The fix is to remove and re-add fields (or recreate the visual) and rebind the flow.

Was this reply helpful? Yes No
lbendlin 8,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

In such a scenario the actual fix is to rebind the array in the trigger step, as the last activity before re-saving the flow.

Was this reply helpful? Yes No