Power BI x Power Automate

[y3wan]

Hi,

I am attempting to run the Power Automate visual as to add a button to export a Power BI dynamic table as a csv file.

However, when I was testing the "On Power BI button clicked", it only delivers blank data to the flow, which further trigger NULL error messages.

If I would just export the table manually it would work perfectly fine.

Am I required to have some sort of pre-paid Power BI or/and Power Automate license in order to run Power Automate visual on Power BI?

Thank you

[lbendlin · Accepted solution]

You need to add the columns of that "dynamic"  (whatever that means) table to the Power Automate Visual.  Then when you push the button, the current filter context based content of these columns will be handed over to the flow.

[lbendlin · Accepted solution]

You need to add the columns of that "dynamic"  (whatever that means) table to the Power Automate Visual.  Then when you push the button, the current filter context based content of these columns will be handed over to the flow.

[y3wan]

Hi @LB 

I have created a dummy dataset and drag all columns to the table before converting it to power automate.

But I couldnt figure out why is the Button triggerd would not deliver any data at all.

As I were adding Compose, Initalize variable, Select flows, I would see those columns under the dynmic contents. But it would then encounter NULL error message which leads me to the button where I found the output restricted as {}

[lbendlin · Accepted solution]

and drag all columns to the table

no, you need to drag all columns to the PowerAutomate visual, not to the table.