BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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:
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:
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:
This is the location for the Power BI store version.
From here deleting the Credentials.bin fixed the issue that we had been having!
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:
The same file for Power Query can be found here:
Hope this helps!
Sam (Wise Owl)