I have a paginated report (which connects to a power BI data set)
And it has two parameters. month and Area
I have a SQL table of the two parameters to use in a Logic App
March 22 Area1
March23 Area 1
March 22 Area 2
I want to be able to automate the creation of a power point slide set and add into a Sharepoint folder.
I have this
So I get the list of parameter sets (In this case there are 3
i add a foreach and then add in Export to File for Paginated Reports
I tell it where to go for the report. Add the parameters
But then it just sits doing nothing. For about 15 minutes
And then fails ActionFailed. An Action failed. No dependent actions succeedeed
Having a look. I can see Parameter values
"name": "Area 1",
"value": "Feb 2023"
And the outputs is StatusCode 400
"message": "RootActivityId(30e6c67c-cbc5-4978-bb6a-ea8da7b388ea): One of the supplied report parameter names does not exist.",
So The report parameters arent right. I think its because I havent hooked up the SQL results to the actual parameters in the Paginated report but Im not sure how.
Is it possible that I havent done something really obvious here? I just cant get this working (Im in Logic Apps NOT Power Automate but its basically the same thing in Azure)