Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors