cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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
Super User III
Super User III

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
Super User III
Super User III

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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.