PostgreSQL ODBC to PowerBI Password

[Anonymous]

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

This is a potential bug, can someone look into it.

Thanks.

[v-yuta-msft]

@Anonymous ,

Please check if power bi desktop can be updated to the latest version.

Regards,

Jimmy Tao

[Amicci]

I have the latest version actually feb 2023 and this issue persists. I have spent the past 3 hours trying to figure this out until I hit this post from 2019 ...
It surprises me that this has not been fixed yet.

The odd thing is when configuring my odbc driver on my local machine it accepts teh % wthout any issue, then I connect using ODBC in powerbi,  point to my correctly configured DSN and then it prompts me again to authenticate, and on this one it fails becauuse of the "%" in the password