Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |