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.

Anonymous's avatar
Anonymous
Not applicable
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

    This works. Thanks a lot for this. The sad thing about this that it requires my machine to be working all the time. Any workarrounds for this rather than hosting a VM for this , because I need this data to be constantly refreshed for my teammates. I will mark this as Accepted Solution.