Secure connection with PostgrSQL

[Maciek_1000]

Hi,

I've managed to make secure connection with my PostgreSQL database. I've struggled to have it connected securely encrypted.

And with my Desktop version I'm using a certificate to validate it. Something like that

Certificate is installed on the server and on my computer. Hovewer I have no idea how to have the same construction in Power BI Service?

How can I establish encrypted connection in PostgreSQL on Desktop and on Power BI service as well? I've manged the first one (to have it on my desktop version, but have no idea how to have connections setup on server. Until now I have this info

Thanks for any hints! 🙂

[GilbertQ]

Awesome thanks for letting us know!

[Maciek_1000]

Thanks @GilbertQ,

After some research you helped me to find I think now I understand the gateway construction. Now it seems that the gateway is necessary. Thanks once again!

[GilbertQ · Accepted solution]

Hi @Maciek_1000 

It appears that you will need to install the On-Premise Gateway. 

Then configure the On-Premise gateway with the same certificate and configuration you have done in Power BI Desktop.

Then finally create the data source to connect via the On-Premise gateway and it should then work.

Cannot connect on-premise gateway with postgres on PowerBI - Stack Overflow

Guidance for deploying a data gateway for Power BI - Power BI | Microsoft Docs

[Maciek_1000]

Hi @GilbertQ,

Thank you for your reply. Installing on premis gateway is exactly what I've done but on my Desktop installation. But in this situation it works only on desktop. I don't know how can I change it and where should I install this gateway so that it can work online (and I could use service for every user, on mobile etc.).

Maciek