cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

[Data Gateway] Unable to connect to the data source

I just set up my Data Gateway on an Azure VM running Windows Server 2012 R2. To set it up, I used the recovery key.

I'm now encountering an error when trying to connect to my Postgres DBs. It previously connected without issue (when running on my PC) and now I'm getting the following error:

Screen Shot 2019-05-14 at 3.39.47 PM.png

The Gateway itself is online. I confirmed that this is the instance running on my Azure VM (turned off PC and it was still connected; restarted the VM and it was no longer connected).

Finally, I have configured the outbound ports on my VM to allow 443, 5671, 5672, 9350-9354. I confirmed this is working properly by running the Network "check now" test.

 

How can I get the connection to work?

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: [Data Gateway] Unable to connect to the data source

I needed to install the Postgres ODBC driver on my server (https://www.postgresql.org/ftp/odbc/versions/msi/).

 

That's why it worked on my local machine but not the server. That's also why PowerBI was able to connect to the Gateway on the server.

4 REPLIES 4
Super User
Super User

Re: [Data Gateway] Unable to connect to the data source

Hi there

Can your new Azure VM Server connect directly to your PostGres database?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Anonymous
Not applicable

Re: [Data Gateway] Unable to connect to the data source

@GilbertQ How would you recommend I test this?

Anonymous
Not applicable

Re: [Data Gateway] Unable to connect to the data source

I needed to install the Postgres ODBC driver on my server (https://www.postgresql.org/ftp/odbc/versions/msi/).

 

That's why it worked on my local machine but not the server. That's also why PowerBI was able to connect to the Gateway on the server.

Highlighted
Super User
Super User

Re: [Data Gateway] Unable to connect to the data source

Hi there

That is indeed 100% correct, because the data will now go through the Gateway server.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog