Forum Discussion

seeeaad's avatar
seeeaad
Regular Visitor
1 year ago
Solved

PowerBi Online Service - PostgreSQL - Encrypted Connection

Hello,   I'm experiencing an issue with connecting to PostgreSQL in Power BI Service. I created reports in Power BI Desktop, connecting to multiple data sources, including my PostgreSQL database. I...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from GilbertQ, please allow me to provide another insight.
    Hi seeeaad ,

    Have you tried connecting to PostgreSQL via ODBC?
    In my testing, after connecting to the local PostgreSQL via ODBC, I can perform the scheduled refresh in the service.

    Please check the following links.

    PostgreSQL data refresh using Data Gateway in Power BI report | by Ramu Vudugula | Medium

    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

seeeaad's avatar
seeeaad
Regular Visitor
1 year ago

Hi, GilbertQ 
Here are the two ways explained in the link you have sent me:

  1. Making an encrypted connection possible by installing a certificate on the remote server: This isn't possible right now because my database doesn't support these certificates. I might acquire them later, but for now, it's not feasible.

  2. Making a connection possible via a gateway: This requires my PC to be running since I serve as the gateway.

What's confusing is that on my desktop, I disable this, and the sync works perfectly fine. However, when I publish it on Fabric, it still tries to connect with an encrypted connection. I can disable the encrypted connection specifically for that data source on Power BI Online, where it shows the connection is successful. But when I try to refresh the workspace inside the semantic model, it still insists on an encrypted connection.