PowerBI API Export to File - Parameters settings for RDL report

[JoergSch]

Hello,

we have several RDL reports on PowerBI and would like to use the "Export To File in Group" API, to generate the report.

This works fine for parameterless reports.

When we are trying this for reports with parameters witht the option "Get values from a query", we have to put in the value instead of the label.

E.g. results from the query:

Value = 1, Label = All

Value = 2, Label = None

In the API Body we have to put in 

"parameterValues":[
         {
            "name":"OrgUnit",
            "value":"1"
         }
      ]

Is there a way to put in the Label field value, like

"parameterValues":[
         {
            "name":"OrgUnit",
            "value":"All"
         }
      ]

Many thanks for your help.

Joerg

[Anonymous]

Hi @JoergSch ,

Please review the content in the following link and check whether it can export RDL reports with parameters using Power Automate.

Multivalue parameters in #PowerBI paginated report when using #PowerAutomate to export to file

Best Regards

[JoergSch]

Hi,

the problem is not the multivalue parameter. The problem is that the parameter is filled by a SQL query with a value and a name. The user is only seeing the Label (e.g All, None, ..), but the Value fields behing that are e.g.  1,2,3,..

When we try to generate the report via API, we have to provide the Value information (1,2,3,..) and not the Label information.

The "End-user" wouldn't know what are the values for each Label.

Best regards,

Joerg