Forum Discussion
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
- Anonymous6 years ago
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
2 Replies
- AnonymousNot applicable
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
- AnonymousNot applicable
Could you please let me know how you're passing multiple values in a single parameter?