Cloud Postgre SQL

[Amrselim1989]

Hello Guys,

Please i need your help,

i have a cloud postgre sql that i can connect with the power bi desktop with a connecter like putty connector very easily,
but when I publish my report to the power bi service, I can't connect with the gateway to apply auto-refresh...

Any help Please?!!!

[lbendlin · Accepted solution]

if it's not an Azure cloud then you have to treat it as "on-premise"  and you need to set up a gateway in the same environment  (or in an environment that can see both your Postgresql database and the Azure Service).

[Amrselim1989]

Hello Guys,

Please i need your help,

i have a cloud postgre sql that i can connect to a power bi desktop with a connecter like Putty connector very easily,
but when i publish my report to the power bi service, i can't connect with the gateway to apply auto refresh...

Any help Please?!!!

[lbendlin]

What type of cloud? Azure?  In that case you may need a VNet gateway, or no gateway.

[Amrselim1989]

no sir, it's not azure, it's just postgre sql Cloud service from Germany, i use Putty to connect power bi desktop, but when uploading to the service, i can no longer connect with it, if you please to help me, please we can arrange a zoom meeting to show you if you please.

[lbendlin · Accepted solution]

if it's not an Azure cloud then you have to treat it as "on-premise"  and you need to set up a gateway in the same environment  (or in an environment that can see both your Postgresql database and the Azure Service).

[Amrselim1989]

Thank you so much sir, this solution worked for me, it appeared that i must install the connector and the gateway on the same server.

[Amrselim1989]

i already can connect to this postgre cloud on a VM that runs 24/7 but only from desktop applications like Excel and Power bi desktop, but when i upload this report to power bi web, the installed gateway can't be seen, i assumed because it's not installed on the same server of the Postgre, but you said " (or in an environment that can see both your Postgresql database and the Azure Service)." that i already have, is there a way to make this gateway visible to power bi web ?!!

[lbendlin · Accepted solution]

 the installed gateway can't be seen

Double and triple check that the connection string is exactly the same between desktop and gateway.  Make sure all on-premise data sources in your pbix are covered by the gateway.  Even the slightest difference will prevent the gateway from being selectable.