Forum Discussion
ODBC Password won't save
Microsoft support helped solve the issue:
for the native postgres connector, I had the Encryption option selected.
going into File > Options & Settings > Data Source Settings > Edit Permissions > and unchecking the "Encrypt Connections" box solved the issue.
for the ODBC connection, there is a % character in the Password I'm using that had to be amended to %25 - once I made that change, Power BI accepted the password. see:
PostgreSQL ODBC to PowerBI Password - Microsoft Fabric Community
When PostgreSQL/AWS password is “11COEde1%23”, but when stored within the registry as a flat text entry, the “%” character is probably not considered during the handshake process. By adding the appropriate ASCII encode “%25”, which is equal to “%”, the connection worked perfectly fine.
By adding the appropriate ASCII encode “%25”, which is equal to “%”, the connection worked
Thanks for the reply.
Unfortunately, the whole reason I'm attempting to go the ODBC route is because there are certificate issues when using the native Postgres connector.
When I do Get Data from Another Source > PostgreSQL database > input server and DB name > input User Name and PW > I get the error "Remote certificate is invalid according to the validation procedure."
However, the engineer administering the DB in question shared the certifcate info, which I've shared a (heavily redacted) screenshot below, and everything seems to be valid.
I have a support ticket open with Microsoft about both the ODBC issue, and the invalid certificate issue ¯\_(ツ)_/¯
error message with Postgres DB connector:
redacted cert info:
And I have gone into the Data Source Settings several times and cleared / re-entered the data for the postgres and ODBC connections, but the result is always the same.
Hi Anonymous,
Since you’ve already raised a support ticket with Microsoft regarding both the ODBC credential handling issue and the certificate validation error with the native PostgreSQL connector, please keep the thread updated and share any insights once the issue is resolved. This may help others facing similar challenges.
Thank you.