Power Automate with in Power BI Desktop issue - Update rows in excel table

[Anonymous]

Hi Community,

I am using this newly added visual - Power Automate with in Power BI Desktop . I am using a flow as mentioned below. I want to click on a button with in Power Bi report and then the data with in Power Automate data should be added to an excel table thats already created and placed in Sharepoint . 

I have 5 different columns in the excel table - Date , Assigned Support Org,Support Group , Pending Count, All Status count . I also have same columns selected in Power BI as well. 

I am trying to run the flow and it has been failing . I am not sure at which step is going wrong . However, I looked at the error message of flow after the run and below is what is says :

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.

Could some one please look at the flow and assist me on how to resolve the issue. 

Thanks,

G Venkatesh 

[ChrisMendoza]

@Anonymous - I am pretty sure you should be publishing to app.powerbi.com in order for the Power Automate Flow to work. I get the same result as you when I run a test within Power BI Desktop however, once I published to my Workspace the flow works as intended.