Power Automate Apply to each error

[Anonymous]

Hello,

I get an error when trying to use apply to each in my flow:

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.

It seems that the data I'm trying to pass from the Power BI report never makes it to the flow.  I can see the data when I show as table:

I'm troubleshooting this issue with a compose operation below.

I see several similar issues posted but can't get mine to work.  Any ideas?

[MattFSharpe]

Praying this works - I have been stuck with this for a ridiculous length of time!

[CaioBrazil]

Thank you very munch!!! I lost most time whit this problem.

[Aurélie541478]

Hello,

I have the same problem, do you find the solution?

[Anonymous · Accepted solution]

When you trigger the flow,  DO NOT use the button below.  Only trigger the flow using the visualization added to the report.

[cjmpetroleum]

I've coded in DAX, Python, HTML, SQL, and others. This type of Automate error behavior is why I think this is the trashiest dumpsterfire product MS has every pooped out.

[jimenezalbert0]

Thank you very much!!!

Hours investigating this!!!