Power BI Report Server - January 2021 update- Cascading parameters is not updating

Meydani, Elahe 1 Reputation point
2021-02-24T10:39:32.303+00:00

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 .... )

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-02-25T02:05:48.277+00:00

    Hi @Meydani, Elahe ,
    Can you run the cascade parameters well before updating?
    If the problem occurs after the update, I suggest you go to the Power BI forum to inquire whether there will be further updated versions. Because it is not within the scope of SSRS, I am sorry that I cannot provide you with more help.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments