cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 200 members 2,033 guests
Please welcome our newest community members: