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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Depending parameters aren't automatically updated in Paginated Reports while in PBIRS/SSRS they do

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

Depending_Parameter_Issue_PBRIS.PNG

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!

Depending_Parameter_Issue_PBI_Premium.PNG   

Status: Accepted
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

I have reported this issue internally: CRI 123838421. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

 

v-qiuyu-msft
Community Support
Status changed to: Accepted
 
Anonymous
Not applicable

Please let me know when the issue will be resolved in PBI Premium.

 

Also, have you also looked into https://community.powerbi.com/t5/Issues/Parameter-datatypes-aren-t-respected-in-Paginated-Reports-in... ?

 

 

v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

I got information that "Opened defect for difference between on premise and PBI Service for Paginated report parameter". Will update to your once I get new information. 

 

Best Regards,
Qiuyun Yu