Forum Discussion
Solved
Add an SSL Certificate to PostgreSQL Database Connection
Hi, I have been using ODBC connection to my PostgreSQL Database because I was unable to get the PostgreSQL connector to work for me due to this error: "An error happened while reading data from ...
UPDATE: I managed to resolve the issue I was having by following these steps which add your SSL certificate to a trusted Windows store:
- Windows Key + R
- Search 'mmc' and hit enter
- In the Microsoft Management Console go to File > Add/Remove Snap-in...
- In the left panel, click Certificates and Add button between left and right panels then OK
- Click the newly added Certificates - Current User in the right panel
- Double-click Trusted Root Certification Authorities
- Select and right-click Certificates > All Tasks > Import
- Follow the Certificate Import Wizard making sure you add your dedicated certificate to the Trusted Root Certification Authorities certificate store
- Finish the wizard import
- Try your Get Data connection again in Power BI
- This didn't work immediately because I had previously stored credentials from an old attempt so make sure in Power BI you go to File > Options and settings > Data source settings and clear permissions for your other connection attempts before trying again
I hope this helps someone, this was an extreme pain to get a Direct Query connection but hopefully now I can finally detect new changes to the database/tables and update my reports as often as I need.
UPDATE: I managed to resolve the issue I was having by following these steps which add your SSL certificate to a trusted Windows store:
- Windows Key + R
- Search 'mmc' and hit enter
- In the Microsoft Management Console go to File > Add/Remove Snap-in...
- In the left panel, click Certificates and Add button between left and right panels then OK
- Click the newly added Certificates - Current User in the right panel
- Double-click Trusted Root Certification Authorities
- Select and right-click Certificates > All Tasks > Import
- Follow the Certificate Import Wizard making sure you add your dedicated certificate to the Trusted Root Certification Authorities certificate store
- Finish the wizard import
- Try your Get Data connection again in Power BI
- This didn't work immediately because I had previously stored credentials from an old attempt so make sure in Power BI you go to File > Options and settings > Data source settings and clear permissions for your other connection attempts before trying again
I hope this helps someone, this was an extreme pain to get a Direct Query connection but hopefully now I can finally detect new changes to the database/tables and update my reports as often as I need.