topic Re: PowerBI API Export to File - Parameters settings for RDL report in Developer

PowerBI API Export to File - Parameters settings for RDL report

JoergSch — Wed, 12 May 2021 13:55:27 GMT

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

Re: PowerBI API Export to File - Parameters settings for RDL report

Anonymous — Fri, 14 May 2021 08:27:57 GMT

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

Re: PowerBI API Export to File - Parameters settings for RDL report

JoergSch — Fri, 14 May 2021 08:50:05 GMT

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