Apply to each failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['entity']?['Power BI values']' is of type 'Null'.

[JAWL]

Dear Experts,

I have a flow that ran successfully previously but now struck by this error (out of the blue as I did not make any change on this step):

The execution of template action 'Apply_to_each_5' 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.

The output for Apply to each is per below:

[edgonzales]

@JAWL 

Hi there.  Most likely, there is a null value in the data coming from Power BI.  Check the trigger output to make sure something is being sent over and that should get you going in the right direction.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[JAWL]

Hi @edgonzales Can we connect at your convenient time via zoom or teams (preferably)?

[edgonzales]

Sent you a PM.

[ASD_111]

Hi @JAWL , Have you able to resolve this error?
I am also facing the same error, can you please help me out, thanks

[Anonymous]

Hello, I have the same problem, what solution did they give you if you could help me please. Thanks

[beatrizfuster]

I'm getting the same error

The execution of template action 'Apply_to_each_9' 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.

Flow was working and now not anymore.

I checked the info coming from PowerBI... and even having selecting a row it shows nothing... 

"body": {

        "entity": {}

How did you fix it?

[alfonsozalazar]

Hi,

Any news about this? I detected the same, the connector is not bringing the info. Tried creating a new flow in the same way and works but I would like to figure it out what happened.

[Bianca_luc_2023]

Olá, 

eu também estou enfrentando o mesmo problema mesmo depois de semanas funcionando normalmente. Alguma solução?