Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SSLMODE used by Gateway with Postgres server data source

Hi   When I connect to on-premise Postgres Server from PBI Desktop with Encryption turned on, the connection uses SSLMODE=verify-full. However, when I connect from Power BI Service Gateway (also wi...
Data Protection
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-xicai 

 

Thank you for reply.

In the current set up, Power BI Gateway uses native Postgres driver, so ODBC is not an option here.

In the case of ODBC, you are right, I can set up verify-full, however I would like to achieve the same by configuring Postgres driver (NpgSql).

From Postgres specification, I can see that this driver uses two parameters: SSL Mode and Trust Server Certificate.

https://www.npgsql.org/doc/connection-string-parameters.html

but there is no way to 'force' this driver to use 'Trust Server Certificate = false' (required for verify-full functionality).

 

v-xicai's avatar
v-xicai
Community Support
5 years ago

Hi Anonymous ,

 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", to get further help.

 

Best Regards,

Amy