Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0

Password via PostgreSQL ODBC is not passsed correctly to server

I am using Power BI desktop Auguest 2019, PostgreSQL x64 ODBC driver 11.03.00.00 (tried both Unicode and ANSI), and seems like passwords are not transimitted to Postgres server when special some characters are included. For example, password Ab!@#$%^&*()-_=+ becomes Ab!@#$�*()-_=+ when it reaches PostgreSQL server.

 

I tested ODBC administrator, and I saw password are transmitted correctly from ODBC client to Postgres server.

 

The screenshot shows when password is passed correctly to Postgres server, from ODBC administrator: ODBC.PNG

And the screenshot below shows password is not passed correctly to Postgres Server from Power BI desktop: 

Power BI Desktop.PNG

 

 

Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @xsgao_pbi

 

Please create a support ticket to get dedicated help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Delivered