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.
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
Solved! Go to 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
Could you please let me know how you're passing multiple values in a single parameter?
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
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.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |