cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fla_made
Regular Visitor

Power BI Data is empty in Power automate

Hi

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.png

 

Button1:

button2.png

 

 

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.

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
HarrievandeSun
Frequent Visitor

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.

Avinash75
Frequent Visitor

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 

Avinash75
Frequent Visitor

@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.

Avinash75
Frequent Visitor

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.

v-rzhou-msft
Community Support
Community Support

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.

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 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Kudoed Authors