Using Export to file for paginated reports in Logic Apps Not Working

[DebbieE]

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

"error": {

    "code": "Invalid_Report_Parameters",

    "message": "RootActivityId(30e6c67c-cbc5-4978-bb6a-ea8da7b388ea): One of the supplied report parameter names does not exist.",

    "details": []

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)

[DragosBI]

Hi @DebbieE  did it finally worked? I try to do same, a paginated report to be distributed based on parameters. It worked without parameters, then trying with parameters, nothing worked anymore. Strange that took out everything, went as at the beggining and still doenst work anymore. No error, just doing nothing for 10 minutes.

[DebbieE · Accepted solution]

Well as soon as i posted this I spotted the error in Parameters. i hadnt set the name and value correctly

i needed to set name to the name of the parameter in report builder