cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnlo109
New Member

Power BI Report Sever

Hi Community,

 

I'm new to Power BI Report Server. So far I have configured the database, apply the web service url & use built-in  account-network service. When using the portal link http:/powebi:80/report. I'm getting the following error. This is actually an upgrade install but I also try the clean reinstall unfortunately the error persist. Any Idea ?

 

file.jpeg

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

This error indicates that your report server database contains encrypted content, but the application layer has the wrong encryption key.

 

There are a number of possible solutions:

 

  1. If you have a backup of the encryption key you can go into the report server configuration tool and restore it
  2. If you don't have a backup you can go into the report server configuration tool and just delete the encrypted content (this is an option under the Encryption Keys section). You will loose any stored passwords, but your other content should remain.
  3. You could uninstall and re-install, but you would need to also go into your SQL Server and delete the old ReportServer and ReportServer_Tempdb databases (assuming they don't have anything in them that you need) before re-installing 

View solution in original post

4 REPLIES 4
d_gosbell
Super User
Super User

This error indicates that your report server database contains encrypted content, but the application layer has the wrong encryption key.

 

There are a number of possible solutions:

 

  1. If you have a backup of the encryption key you can go into the report server configuration tool and restore it
  2. If you don't have a backup you can go into the report server configuration tool and just delete the encrypted content (this is an option under the Encryption Keys section). You will loose any stored passwords, but your other content should remain.
  3. You could uninstall and re-install, but you would need to also go into your SQL Server and delete the old ReportServer and ReportServer_Tempdb databases (assuming they don't have anything in them that you need) before re-installing 

hi @d_gosbell 

 

I am having a similar issue. We have a report server running for a while, and this morning the server is rebooted as no one can access it. After rebooting, everything else is working again except for the PowerBI report server. 

 I tried to reconfigure the report server but it couldn't solve the problem. In photo 3, that I don't have the encryption key backup, I delete the current key and backup a new one. Since I would be able to access the report server again, all the reports are gone. Is there any way that can restore the report data as well?

 

Could you please guide me to restore the prior data in Power BI Report Server?

 

Thank you very much!

 

leahYan_0-1599540579979.jpeg

leahYan_1-1599540586549.jpeg

leahYan_2-1599540645832.png

 

 


@leahYan wrote:

 I tried to reconfigure the report server but it couldn't solve the problem. In photo 3, that I don't have the encryption key backup, I delete the current key and backup a new one. 

 


Without a backup and since you've created a new key your only option is to click the button in the Configuration Manager to delete all encrypted content. It's only really things like username/password details for data sources that get encrypted, all of your reports will still be there.

 

However it's worth double checking the service account and your email settings in the Configuration Manager while it's open. I'm not sure off the top of my head if these are encrypted the same way.

 

Hopefully once you've deleted all the encrypted data the portal should open and your reports should appear. You will then need to go through all of them and re-enter any username/password details that were stored against any of your data sources. Without the original encryption key there is no way to recover this information and it will just have to be re-entered.

Thanks!!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!