Forum Discussion

SteiniJonsson's avatar
SteiniJonsson
Frequent Visitor
6 years ago

Error with query parameters (from shared datasets) after upgrading to January 2020 PBIRS

Hi   After upgrading to the January 2020 version of Power BI Report Server some of the reports failed with this error. An error has occurred during report processing. (rsProcessingAborted) The e...
January 2020
PBI Report Server
robertjordanmmc's avatar
robertjordanmmc
Frequent Visitor
6 years ago

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*/

 

  • SteiniJonsson's avatar
    SteiniJonsson
    Frequent Visitor
    6 years ago

    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