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

[v-linhuizh-msft · 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.