The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello dear Community,
I need your help.
We have many reports (.rdl) in PowerBI Report Server. Most of these reports are using Cascading parameters. For example, we have a ClientNo parameter, it is a dropdown menu. When the user is selecting it, the dependent date parameters are filtered based on the ClientNo. And when the ClientNo is changed, the date values are refreshed based on the new ClientNo.
But unfortunately, after we updated the Report Server to January 2021, this functionality is lost. The dependent parameters are not refreshing when the parent parameter is selected or changed.
I searched a lot on the web, and I tried almost all the answers, but none of them seems to work.
Consider this, that we have at least 100 reports, and we can not apply a fundamental change to all the reports. ( cause some of the solutions were suggesting to set the parameter data sets to a stored procedure .... )
@Anonymous
Try return to the previous version Report Server if you still have the install pack, see if the parameters are working properly. You may leave a feedback in the following post regarding to the Jan updates bug.
Power BI Report Server Jan 2021 Released - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
8 | |
4 | |
4 | |
3 | |
3 |