Power Automate Visual does not pass on the data, only an empty entity array results

[gunnarg]

I have simplified the problem by passing only one measure to the Power Automate visual and one select action after the "On Power BI button clicked". I get the desired single-line output when I select "Show as table" on the visual menu with no null values. But when I run the flow, the data gets lost, and the "On Power BI button clicked" output is only an empty array, { }, entity. Since I have a Null value in the first step, the Power BI data in the dynamic content is also NULL, hence the input error in the Select action. I do not know what is happening, as I have used the Power Automate Visual many times successfully. I am logged on using my company's email address and the company's default environment. I would be very grateful if someone could resolve this issue, as I have been working on it for hours now to no avail.

[valgof1]

Hi, This morning all my flows that were running a similar set-up had an "invalid connection" issue. When refreshing the connection, the code behind the "On Power BI button clicked" also seemed to have changed automatically. I am now getting an empty body as well as output of this operation, which is causing all my flows to fail. Nothing changed in my Power BI report.

Update: I opened the Power Automate flow from the embedded button within my Power BI report, deleted the trigger and recreated it from there (instead of doing it from the online version). It solved the issue (still crazy that it was working and that simply updating the connection/credentials completely changed the code behind the button and led to this issue).

[gunnarg]

Thanks so much for your comment, @valgof1! I did the same as you, and it worked perfectly. I deleted the trigger and recreated it, and the data flow began.

[v-xiaoyan-msft]

Hi all,

I'm glad you found workaround and shared it, for those of you who have had similar experiences check out the comments below.

Best regards.
Community Support Team_Caitlyn