Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to create a csv file using powerautomate. When I select compose, under inputs, I am unable to see the "PowerBIdata" option. All it shows are userid, username,body, entity and item. Is there anything else I need to setup? Please suggest.
Thanks,
Solved! Go to Solution.
you need to create the flow from within the Power Automate visual in Power BI Desktop. Otherwise you won't get the PowerBIData object.
Hello @lbendlin
I thought I got this. But on a second try, I do not see the "Power BI Desktop" option. What am I doing incorrectly?
In my report, I just have a table visual and I am connecting Powerautomate from PBI desktop.
Thank you.
The table visual is irrelevant. The only thing that is important is the PowerAutomate visual.
Looks like you have wired it up correctly. Where are you stuck?
Thank you @lbendlin for your inputs and help. That was my bad. I accidentally did not choose the columns. Sorry for that.
One more question. When I create tasks, sometimes the powerautomate button is not getting clicked. Is there any inputs/reasons on that?
I don't know what you mean by "create tasks"
In Power BI Desktop you need to CTRL-click the visual to initiate the flow. In the service you can do a simple click.
@lbendlin I meant creating a flow in powerautomate. I am trying CTRL-click only. But nothing is happening most of the time. Looks to be like a plain button without action. I restarted system as well.
When I go inside powerautomate and run manually, I get error
"The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['entity']?['Power BI values']' is of type 'Null'. The result must be a valid array."
This was running fine earlier. I was just trying to create a task which creates and write a csv file to onedrive.
Task has create array--Assign to variable--Create csv and write to onedrive.
The Power Automate visual in Power BI works based on two assumptions
1. you tie data from your Power BI data model to the Power Automate visual
2. you create the Power Automate flow via the Edit button on the visual
If both assumptions are met you will be able to reference/consume the Power BI data in the newly created flow.
You seems to have tried an approach without item 1, and potentially without item 2. While technically possible, this is not recommended.
Thank you. I also had to upgrade my PBI desktop.
you need to create the flow from within the Power Automate visual in Power BI Desktop. Otherwise you won't get the PowerBIData object.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |