topic Re: Power BI Data is empty in Power automate in Developer

Power BI Data is empty in Power automate

fla_made — Mon, 28 Feb 2022 16:37:52 GMT

I have a report with an existing button that triggers a flow to run, I'll call this one Button1.

I added a new button with the requirement to trigger a different flow from the Power BI report, this will be Button2.

Button1 works perfect and I can see the data passing to power automate without a hitch. Button2 however shows no data when I look at the flow. Whats even more confusing is, while debugging, I passed the exact same first parameter from Button1 into Button2 and still no data is showing on the power automate side for the new flow. HOWEVER, when I choose to trigger the same flow from Button2 as Button1 then I see the data gets passed.

Here shows the two button triggering the flow with the inputs visible

Button2:

Button1:

Is there a limit to the number of flows that can be connected to a report? I looked in the docs regarding this functinoality and seen nothing mentioning this.

Thank you everyone for any help with this issue.

Re: Power BI Data is empty in Power automate

Anonymous — Thu, 03 Mar 2022 06:34:06 GMT

Hi @fla_made ,

Please check the known limitation from the offical blog.

Know Limiations

The user running the flow within the Power BI report needs to have permissions to run the flow. Grant these permissions through direct sharing by the user or by sharing to an Azure Active Directory group.
The Power BI visual only functions with flows in a tenant's default environment. Any flow created with the visual is created in the users default environment.
Additional manual inputs to the button are not supported at this time.
Create flows that you will use with the Power BI button trigger directly within the Power BI report. Do not go directly to Power Automate to create these flows as the trigger will not have access to the data fields necessary for creating the flow.
Power BI data is sent to, and processed in, a geography where the flow is deployed.
The Power Automate visual isn't supported for PaaS-embedded scenarios, nor in sovereign cloud scenarios.

For reference:

Trigger a cloud flow from any Power BI report

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI Data is empty in Power automate

Avinash75 — Thu, 25 Aug 2022 16:41:29 GMT

I checked the restrictions and all look good for me. I have one power BI where the button works fine. And then I was working on another PBI file the flow was working fine and suddenly it stopped sending any data, since than i have tried everything with no success.. creating new PBIX file, creating new button, creating a new flow with only a compose action to catch the trigger body, removing filter interactions from button and for whatever reason I cannot get any data to be sent across to my power automate flow.

Any ideas on how we can debug the calls and check if data is being sent or tips to fix the issue.

Re: Power BI Data is empty in Power automate

fla_made — Thu, 25 Aug 2022 23:52:34 GMT

This is still An issue for me that was never solved by the other answer. My work around was to go to the one flow I have that works and doing a save as, this for some reason works fine. Inconvenient but works

Re: Power BI Data is empty in Power automate

Avinash75 — Fri, 26 Aug 2022 08:21:51 GMT

@fla_made thanks for sharing your experience, your workaround is the one I didnt try yet. I will try and update if it works coz my working button and flow is from a different PBIX file.

Re: Power BI Data is empty in Power automate

Avinash75 — Sat, 27 Aug 2022 21:52:28 GMT

Your workaround worked .thanks a lot for guidance. I will keep using this till someone or Microsoft comes with a solution or workaround. @fla_made

Re: Power BI Data is empty in Power automate

HarrievandeSun — Tue, 16 May 2023 13:04:42 GMT

Hi,

I got this problem as well after I turned on Concurrency Control in Power Automate.

Since it is not able to turn off concurrency control again, I built a new flow and applied it to the button and everything worked again.