Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I'm trying to connect to a PostgreSQL database that now is now secured with SSL. I was able to connect to it previously now I'm getting the unable to connect error. Our team developer has created a non ssl user and I still get this error. Does PowerBI allow connections to secure databases? What can I do to get this connection working but keep the secure integrity of the database?
Solved! Go to Solution.
Hi @justinrae,
Power BI Desktop allows connections to secure databases. Based on my research, to make Power BI Desktop work with PostgreSQL that is secured with SSL, you would need to copy SSL certificate for the PostgreSQL server to the machine running Power BI Desktop and import it to Windows certificate store. Because Power BI Desktop uses the windows certificate store to decide what to trust, once you tell the Windows that is running Power BI Desktop to trust the SSL certificate for the PostgreSQL server, Power BI Desktop will trust it too.
In addition, in the configuration folder for the PostgreSQL server there is a postgresql.conf file, search it for SSL settings, there is one with the location of the SSL certificate. Take a look at the server name when you import the SSL certificate and connect from Power BI Desktop using the same server name. Then check if the above error goes away.
There is a similar thread for your reference.
http://community.powerbi.com/t5/Integrations-with-Files-and/Postgres-error-with-Power-BI-Desktop/td-...
Thanks,
Lydia Zhang
Hi @justinrae,
Power BI Desktop allows connections to secure databases. Based on my research, to make Power BI Desktop work with PostgreSQL that is secured with SSL, you would need to copy SSL certificate for the PostgreSQL server to the machine running Power BI Desktop and import it to Windows certificate store. Because Power BI Desktop uses the windows certificate store to decide what to trust, once you tell the Windows that is running Power BI Desktop to trust the SSL certificate for the PostgreSQL server, Power BI Desktop will trust it too.
In addition, in the configuration folder for the PostgreSQL server there is a postgresql.conf file, search it for SSL settings, there is one with the location of the SSL certificate. Take a look at the server name when you import the SSL certificate and connect from Power BI Desktop using the same server name. Then check if the above error goes away.
There is a similar thread for your reference.
http://community.powerbi.com/t5/Integrations-with-Files-and/Postgres-error-with-Power-BI-Desktop/td-...
Thanks,
Lydia Zhang
I'll give this a shot and let you know how it goes. I'm assuming it'll be the same thing with accessing secured MySQL databases?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
54 | |
27 | |
15 | |
14 | |
13 |