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.
Hi
After upgrading to the January 2020 version of Power BI Report Server some of the reports failed with this error.
The last line of the error is the interesting one.
After doing a trace on the sql server while running the report I found that the query from the ReportData dataset had an additional letter added to the query at the end one of the predicates. This part of the query then looks like:
and m.Column1 in (N'Value1',N'Value2's)
If only a single parameter value is selected the additional s is not added and the report runs just fine.
The parameter values are coming from shared datasets.
Has anybody else experienced anything like this and do you have a solution/workaround (other than the obvious, rollback to the previous version of PBIRS)?
Best regards,
Steini
We are seeing the same issue on our Dev machine which has been upgraded to January 2020 PBIRS.
It appears to me to be happening when I have two different parameters that start with the same name i.e. @Family & @FamilyClass
only I'm getting the error on "Class"
it is obvious in the trace that it is using @Family:
AND em.[EquipFamClsCdAbbr] IN (N''GU'',N''G27'',N''GE'',N''GR'',N''GF'',N''G1'',N''GC'',N''GG'',N''GN'',N''G21'',N''G24''Class) /*<--Should be @FamilyClass*/
AND em.[EquipFamCdAbbr] IN (N''GU'',N''G27'',N''GE'',N''GR'',N''GF'',N''G1'',N''GC'',N''GG'',N''GN'',N''G21'',N''G24'') /*<--@Family*/
In our case the parameter name in the query is the same as the name of the parameter passed to the query (parameter value).
After changing the parameter name the report runs without an error.
Regards,
Steini
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 |
---|---|
10 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
13 | |
10 | |
7 | |
3 | |
3 |