Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
michalw88
New Member

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

Hello,

 

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

- I add columns to the Power Automate's visual 

michalw88_0-1730224029047.png

 

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

michalw88_1-1730224071909.png

 

- 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'." 

michalw88_4-1730224232235.png

- 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

 

 

1 ACCEPTED SOLUTION
v-linhuizh-msft
Community Support
Community Support

Thanks for the replies from lbendlin.

 

Hi @michalw88 ,

Based on your description I reproduced your question.

vlinhuizhmsft_0-1730450228896.png

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

vlinhuizhmsft_1-1730450324179.png

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

vlinhuizhmsft_3-1730450663448.png

 

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.

View solution in original post

7 REPLIES 7
v-linhuizh-msft
Community Support
Community Support

Thanks for the replies from lbendlin.

 

Hi @michalw88 ,

Based on your description I reproduced your question.

vlinhuizhmsft_0-1730450228896.png

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

vlinhuizhmsft_1-1730450324179.png

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

vlinhuizhmsft_3-1730450663448.png

 

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.

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)

michalw88_4-1730715019131.png

 

Thank you both for advise!

Best Regards,

Michal

lbendlin
Super User
Super User

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

 

Note:  The Compose step is not required.

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

michalw88_0-1730230932338.png

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

 

On your flow run, check the raw output

 

lbendlin_0-1730231618019.png

 

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

 

michalw88_0-1730232464281.png
🤔

 

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.