cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rohithkothaneth Regular Visitor
Regular Visitor

How to retain the connection post an upgrade

Hello,

I had recently upgarded my Power BI Report Server and database to Jan 2019 version. Upon upgrade when configuring back to the same database, I had to delete the encrytion key for fresh key to install. But doing any refreshes scheduled for any reports stopped from doing so. I had to re-enter the credentials agian for it to refersh the data. Is it a common issue here?

Would this need to be done everytime I upgarde to new version?

 

Thanks,
Rohith

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to retain the connection post an upgrade

So if you delete the encryption key and re-created none of your stored passwords will work any more which will probably break any scheduled refreshes you have. The key works sort of like a password, so the server now has no way of decrypting any of the stored credentials.

 

However the upgrade should not force you to re-create the key. I've upgraded 2 of our dev instances and neither of them required this. Having said that it's probably a good idea to back up your encryption key before doing any updates in future so that you can simple restore the existing key if you have any issues.

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: How to retain the connection post an upgrade

So if you delete the encryption key and re-created none of your stored passwords will work any more which will probably break any scheduled refreshes you have. The key works sort of like a password, so the server now has no way of decrypting any of the stored credentials.

 

However the upgrade should not force you to re-create the key. I've upgraded 2 of our dev instances and neither of them required this. Having said that it's probably a good idea to back up your encryption key before doing any updates in future so that you can simple restore the existing key if you have any issues.

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)