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.
Hi @Anonymous ,
You may use the ODBC connector to get PostgreSQL server data source in Power BI Desktop, and force the SSLMode=verify-full, see more details: Tutorial: how to configure Power BI to connect to PGSQL ran by Meiro .
Driver={PostgreSQL Unicode(x64)};Server={host_domain};Port={port};Database={name_of_ the_database};SSLMode=require;UseUnicode=1;
Further references under this link.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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).
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
@Anonymous Have you reviewed the documentation here?
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-indepth
Probably have to edit the gateway config file.
Thank you for the hint. I haven't looked into this document yet. Let me read it and if I find the answer there, I will mark your answer as the solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.