Forum Discussion

fla_made's avatar
fla_made
Regular Visitor
4 years ago
Solved

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:

 

 

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.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • fla_made's avatar
      fla_made
      Regular Visitor
      4 years ago

      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 

  • Avinash75's avatar
    Avinash75
    Frequent Visitor
    4 years ago

    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.

  • Avinash75's avatar
    Avinash75
    Frequent Visitor
    4 years ago

    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's avatar
    Avinash75
    Frequent Visitor
    4 years ago

    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 

  • HarrievandeSun's avatar
    HarrievandeSun
    Frequent Visitor
    3 years ago

    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.