topic Re: Multi-Valued Parameters When Using Enter in Parameter Input Throws Error (Power BI January Release) in Report Server

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

Anonymous — Fri, 06 Mar 2020 18:39:52 GMT

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

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

Anonymous — Fri, 06 Mar 2020 19:49:30 GMT

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

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

Anonymous — Wed, 05 Aug 2020 15:40:24 GMT

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