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.
on:
Power BI Desktop issues starting March 2025 releas...
SamWiseOwl
on:
Default to Current Date