Multi-Valued Parameters When Using Enter in Parameter Input Throws Error (Power BI January Release)

[Anonymous]

Existing Power BI Report Server reports that were working fine with multiple value parameters are no longer working when using Enter in the parameter dropdown input.

An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for dataset 'dataset_name'. (rsErrorExecutingCommand)

Incorrect syntax near '2'. An expression of non-boolean type specified in a context where a condition is expected, near ','. Incorrect syntax near ')'. Incorrect syntax near ')'.

In looking at the report execution it shows the reports that fail with the follow parameter values entered for a single parameter:

&PARAM=11111&PARAM=22222

If you enter the parameter with comma's already in the input it works fine, the report execution shows:

&PARAM=11111%2C22222

[Anonymous]

Could you please let me know how you're passing multiple values in a single parameter?

[Anonymous · Accepted solution]

We loaded the latest release from March 2nd, 2020 (version: 1.6.7364.4075) and this resolved the parameter issues.

https://docs.microsoft.com/en-us/power-bi/report-server/changelog