Forum Discussion

cyy247's avatar
cyy247
Frequent Visitor
4 years ago
Solved

Received an error after upgrading Power BI Report Server to January 2022.

We always follow Power BI Report Server's release to upgrade our on-premise Power BI Report Server. After upgrding our Power BI Report Server from September 2021 to January 2022, an error was thrown....
Report Server Configuration Manager
  • cyy247's avatar
    cyy247
    4 years ago

    I resolved this issue with the dumb way.

     

    1. I ran the January 2022 Power BI Report Server package to "repair" the application. This step restore the Report Server Instance to the Power BI Report Server.
    2. After the repairs, the dashboards having the “System.Security.Crytography.CryptographicException” issue so I deleted the currect encryption key, and create and save a new one.
    3. Deleted/uploaded the currect dashboards per requirements of the "Data sources" and applying the connection strings to all operational dashboards.

    Thanks.

     

     

cyang4's avatar
cyang4
Icon for Helper I rankHelper I
4 years ago

Hi FarhanAhmed,

 

Many thanks for your reply. 2 questions below are confused me. Please advise.

 

  1. Do I re-apply the SQL Server license if the 2019 ISO is downloaded from the volume licensing?
  2. Based on the screenshot, is an "Enterprise" SQL Server required for an on-premise Power BI Report Server?
  3. Yes, PBIRS can access DBServer through Report Server Configuration Manager. But it only can see SSRS instead of the database "PowerBI". When changing the database from ReportServer (SSRS's database) to PowerBI through "Change Database", it shows another error 

We hosted the Power BI Report Server since July, 2017. A SQL Server Standard was all fine on September 2021 and all its previous releases until its January 2022 release.

 

Thanks again!

  • cyy247's avatar
    cyy247
    Frequent Visitor
    4 years ago

    I resolved this issue with the dumb way.

     

    1. I ran the January 2022 Power BI Report Server package to "repair" the application. This step restore the Report Server Instance to the Power BI Report Server.
    2. After the repairs, the dashboards having the “System.Security.Crytography.CryptographicException” issue so I deleted the currect encryption key, and create and save a new one.
    3. Deleted/uploaded the currect dashboards per requirements of the "Data sources" and applying the connection strings to all operational dashboards.

    Thanks.