Power Automate and Power BI

(0) Share

Report

Posted on by LuisDataReady

Hi friends

I'm stuck with a problem with Power Automate and Power BI. I'm using sharepoint list to connect de data with BI and use Power Automate to streaming data. The problem is that I have some columns as Register Date that with date values. Then I have another list with the payroll calendar in the steps "Get Items". What I want is to "create" a new column with the payday, for example mi sharepoint list has a date value as "12-01-2022", then I want a kind of "lookup" to add a new column with the payment day as "24-01-2022".

I used conditionals to get a result, but when I put the step in the Power BI box it gives me an error as below:

"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Add_rows_to_a_dataset' at line '1 and column '1314' is invalid."