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?
Solved! Go to Solution.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.