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
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