Power Automate in Power BI: error - "from property is of type null"

[michalw88]

Hello,

My final goal is to create CSV export via Power Automate's visual.

- I add columns to the Power Automate's visual 

- I add two more steps to the flow (Compose, Create CSV)

- I run to test -> it fails with error: "The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'." 

- From what I see in last screenshot, the initial step in the flow ("On Power BI button clicked") does not produce any output.

- Thus, in the "Compose" step, both "Input" and "Output" are opening as blank HTML pages (obviously, since nothing is coming from previous step).

Could anyone please advise what am I missing? I am pretty new to Power Automate.  

Best regards,

Michal

[Linnil]

I have used this Flow (download to SP file from PBI, using a button trigger) and it was working fine in both PBI desktop and published. I added a couple of fields to my report and NOW I am getting the very same error message.
The above example does not explain why it would be occuring in my case. the data is coming from a CSV file in SP.
I would not think adding 2 text fields would cause this issue.
I have refreshed and saved in as many places as I could think of / making sure I didn't miss anything.
Any suggestions welcome.

[lbendlin]

Raise a ticket. We see the same behavior (new and changed flow visuals having empty payload) and we raised a ticket.

[Linnil]

Hi - is there a ticket I can add a vote to?
I don't know how to raise this ticket efficiently. 

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[Linnil]

That's didn't really help either but thanks

[Anonymous · Accepted solution]

Thanks for the replies from lbendlin.

Hi @michalw88 ,

Based on your description I reproduced your question.

Is this what you get when you click “Run” in the image below?

Please hold down the Ctrl key and click on this visual.

Best Regards,
Zhu
Community Support Team

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

[michalw88]

Now I see - so basically

• testing the flow while in Edit Mode (as I described) fails due to body= null,
• but if I go out and just trigger the flow from the outside using a button it works (tested, I can confirm)

Thank you both for advise!

Best Regards,

Michal

[lbendlin]

Looks like you forgot to provide the Power Automate visual in Power BI with actual data?

Note:  The Compose step is not required.

[michalw88]

I am actually adding two columns to the visual, as below. (sample data)

Altohugh that error may sound like I am not doing so. 

[lbendlin]

On your flow run, check the raw output

[michalw88]

I don't even see raw output. Just Body{}

🤔

[lbendlin]

Sounds like it is time to start over.  Add the flow visual, add the values, then edit the visual and edit the flow.