Browse 554 attributed reviews, viewable separately for our classroom and online training
Solving FAILED TO DECRYPT CREDENTIALS message when running Power BI
Following the April 2021 update to Power BI (perhaps coincidentally) we started getting this message appearing on our computers, blocking us from running Power BI. Here is how to solve this!

Posted by Sam Lowrie on 20 April 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

FAILED TO DECRYPT CREDENTIALS when running Power BI

Perhaps by coincidence when the Power BI April 2021 update arrived the Wise Owl computers started throwing up this error:

Decrypt Credentials

Aah ... Microsoft error message.  So informative.

This incessant pop up would prevent any form of SQL connection, and any attempts to delete the saved credentials would result in its return:

Can't delete

On the Home tab clicking the Transform Data drop down reveals Data Source settings, but this didn't help!

If it's not possible to delete credentials here, then they must be saved somewhere locally. By searching the error log (Copy details to clipboard) I found this location:

Credentials

This is the location for the Power BI store version.

From here deleting the Credentials.bin fixed the issue that we had been having!

Data source properties

Now the connections work, and when I check a new Credentials.bin file has been generated.

I hope this clears up your issue too!

If you are using the installed version of Power BI the location is at:

C:\Users\Trainee\AppData\Local\Microsoft\Credentials

This blog has 2 threads Add post
22 Apr 21 at 07:54

Hi PATO,

The same file for Power Query can be found here:
C:\Users\Trainee\AppData\Local\Microsoft\Office\16.0\PowerQuery\User.zip\Credentials

Hope this helps!

Best regards

Sam (Wise Owl)

22 Apr 21 at 08:24

Thanks it worked

Have a safe day.

21 Apr 21 at 16:00

Having the same problem with Excel power query, any ideas??