Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
It seems that depending parameters aren't automatically updated in Paginated Reports while in PBIRS/SSRS they do.
For example, if a paginated report has two integer based parameters called 'Century' and 'YearNo' which can be changed by the end user, and a third one called 'Year' is depending on the input of 'Century' and 'YearNo' (possible value and default value ‘Year’=’Century’ + ‘YearNo’), then parameter 'Year' isn't automatically updated if one of the depending parameters (Century, YearNo) has been changed by the end user. The end user must explicitly select the 'Year' parameter again in PBI Premium while the given parameter automatically gets updated in PBIRS/SSRS.
This issue causes additional actions to be done by the end user, but more importantly, hidden (or internal) parameters that are depending on the input of other parameters can’t be used in Paginated Reports via PBI Premium in the cloud, while in (normal) PBIRS/SSRS they can!
Screenshot PBIRS/SSRS after updating ‘YearNo’ to 19 and leaving ‘Century’ to the default setting of 2000: Year automatically gets updated to 2019
Screenshot PBI Premium after updating ‘YearNo’ to 19 and leaving ‘Century’ to the default setting of 2000: The possible value to be selected gets indeed updated. However, the end user must select the parameter again!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.