Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Issue with similar parameter names in Jan 2020 Power BI Report Server (15.0.1102.759)

We upgraded to Jan 2020 version on our Development server yesterday and found a problem with how reporting services is passing the multi-value parameter values in ad-hoc query. 

 

A simple explanation of what is happening

1. We have a report with multi-value parameter name @School

2. There is a dataset with an ad-hoc query which has variable name @SchoolYear and using the values coming from @School parameter

 

DECLARE @SchoolYear INT

SET @SchoolYear = MAX(SCHOOL_YEAR) FROM DIM_SCHOOL

 

SELECT *

FROM DIM_SCHOOL 

WHERE SCHOOL_ID IN (@School) --parameter 

 

The report is failing when I pass more than one values for @School parameter because reporting services is replacing @SchoolYear variable with the @School values. 

 

DECLARE N'496',N'375'Year INT

SET N'496',N'375'Year = MAX(SCHOOL_YEAR) FROM DIM_SCHOOL

 

The same report works fine in another server with Mar 2018 PBI Report Server. 

 

 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @pmetaliya,

 

Please create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

pmetaliya
Frequent Visitor

hi @v-qiuyu-msft,

I don't mind creating a ticket but Power BI Report Server is missing from Problem Type while creating it. I posted here because the issue I've described is a product bug that should be fixed.