Dynamic Power BI content not shown in power automate

[tanehome1]

Hi all, I would appreciate help with this.
I am trying to create a Power Automate flow in Power BI, to export my Power Bi data to a CSV file .

As attached Image, the Dynamic content not shown at all to select from it.

  at all to select from.

[v-menakakota]

Hi @tanehome1 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @tanehome1 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[lbendlin]

That's most likely not the approach you want to take anyway (Instead run a DAX query from Power Automate) but your issue is caused by meta data mismatch because you have changed the columns assigned to the Power Automate visual in Power BI.  Start over with a fresh flow that includes all required fields.

I am not aware of a way to enforce the meta data changes from Power BI to Power Automate - would be interested to know if someone has found a way.

[tanehome1]

actually, this is a new flow as i did not create any flow before and didn't did not change columns assignement and don't know how to do

[lbendlin · Accepted solution]

Great, so starting over won't be painful.

Add all the required columns to the Power Automate visual.  Click the three dots on the visual, click "Edit".  Create a new flow.  You will then be able to use all the columns.

[tanehome1]

it works fine regarding retreiving the data columns, but another issue has been appeared while using the dynamic USER EMAIL in the "TO" field to send the email based on logged in user nothing happen while entering static email works fine.

when tracking USER EMAIL by buting it in the mail body found it retreiving "VEFIYxxxxxxxxxxxxxxmV0" instead of the email address

any thought?

[lbendlin]

It's Base64 encoded.

[tanehome1]

sure encoded, just wondring why email not sent using the dynamic way?

[lbendlin]

i don't understand your question. Please elaborate.

[tanehome1]

i means as per the configuration in the below photo, no email sent (with exported csv) when trigger the power automate

while when replace the "user email" parameter with static email address, email sent successfully with exported data.

[lbendlin]

Encapsulate the "user email"  field in a Base64 decode action.

Reference guide for expression functions - Azure Logic Apps | Microsoft Learn