Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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