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.
Hello,
We are encountering issue after report builder upgrade from 14.x to 15.x version, where rdl files using parameters with "allow null value" setting isn't working as expected anymore.
We are unable to run the reports and get the following error message expecting a value to be entered.
Not sure if the way this function works has changed after upgrade, appreciate any help on this!
Thank you!
Solved! Go to Solution.
Hi @Abdelmajid ,
According to the error message you provided:
The EXECUTE command for a parameterized SQL stmt specifies a list of parameters. The number of parameters in that list must equal the number of parameters that appear within the SQL statement.
Please correct the SQL statement and resubmit.
If I have not understood your needs correctly, please do not hesitate to inform me.
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Abdelmajid ,
According to the error message you provided:
The EXECUTE command for a parameterized SQL stmt specifies a list of parameters. The number of parameters in that list must equal the number of parameters that appear within the SQL statement.
Please correct the SQL statement and resubmit.
If I have not understood your needs correctly, please do not hesitate to inform me.
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |