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.
Dear community,
I've built a Power Automate flow that uses a SharePoint action to generate a PBI paginated report. Now, one of the parameters is multi-value and I'm having issues to pass this variable from Automate to PBI. If I pass the array object, I get the error "The parameter(s) "<param>" has invalid values.". After that, I tried passing as string, using colon as well as semi-colon, but kept giving the same problem. How does Power BI expect the parameters to be passed?
Best regards,
W
Solved! Go to Solution.
Hi @WouterV ,
I also suggest you to create a post in power automate forum. And in power bi you should set Allow multiple values property for the parameter:https://docs.microsoft.com/en-us/power-bi/report-builder-parameters#bkmk_Report_Parameters
And if you need to Pass a report parameter in a URL , The format for a multi-value parameter is to repeat the parameter name for each value. please refer to the example in this document: https://docs.microsoft.com/en-us/power-bi/report-builder-url-pass-parameters#additional-examples
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks for your input. To elaborate on your comments:
Initialize an empty array variable
For each loop for parameter values
in loop:
1) compose:
{
"name": "paramname",
"value": "@{items('Apply_to_each')}"
}
2) append to array variable
Exit loop
In PBI action, switch param input to array
ParameterValues is your array variable
Hi @WouterV ,
I also suggest you to create a post in power automate forum. And in power bi you should set Allow multiple values property for the parameter:https://docs.microsoft.com/en-us/power-bi/report-builder-parameters#bkmk_Report_Parameters
And if you need to Pass a report parameter in a URL , The format for a multi-value parameter is to repeat the parameter name for each value. please refer to the example in this document: https://docs.microsoft.com/en-us/power-bi/report-builder-url-pass-parameters#additional-examples
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks for your input. To elaborate on your comments:
I think you are missing the filter keyword.
Should be like this:
Thanks for clarifying, though still doesn't seem to work. To edit the code directly, I had to export, edit the json, and import again. It fails on the import step, without giving a proper error message. Given this is the only thing I touched in the json, either it's still my syntax or this type of action won't accept "filter"?
The value I put:
{
"filter": "DataSet1/Param1 in (@{variables('Categorie')})"
}
Were you able to get a similar flow working this way?
Use the same syntax as here.
Filter a report using query string parameters in the URL - Power BI | Microsoft Docs
Power Automate will then translate that into the JSON format required by the API call.
Thanks for the suggestion, but still throwing the error. Either I'm not applying it correctly, or this syntax is not possible in the "export to file for paginated reports" action. Let me describe what I have done now:
When triggering the flow, I'm getting this in the json:
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.