How to format Power BI variables in PA flow? Variables disappear after selecting "Expression".

[Anonymous]

Hello,

I have a Power BI button attached to a Power Automate flow and I need to configure formats for the "estimatedStart" and the "Sum of percentComplete" but the variables don't appear in the area where I would normally format them (see image). I can select them initially but I can't after selecting anything in the "Expression" area.

What am I missing?

Thx.Can't access variables once formulas/formating selection is made

[Anonymous · Accepted solution]

Hi @Anonymous ,

• 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.
• The Power Automate visual will not work for published reports because the users are unauthenticated.
• The Power Automate visual is limited to process a maximum of 1000 records.

Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Learn

Best Regards
Community Support Team _ Polly

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