cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vrocca Member
Member

Configure Gateway to connect to PostgreSQL

I'm running into an error when trying to create a new data source on my data gateway:

 

 

Cannot connect to the mashup data source. See error details for more information.

 

PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'. This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'Npgsql version 2.0.12': https://go.microsoft.com/fwlink/?LinkID=282716

 

Has anyone ran into this before? Other similar questions seem to be specific to when establishing the connection on Power BI Desktop. The solution there is to download the data provider. 

 

Do I need to install this on the server hosting the data gateway??

Thanks,
Victor Rocca | www.victorrocca.com
2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
vrocca Member
Member

Re: Configure Gateway to connect to PostgreSQL

2 Things to get this to work:

 

1. Install the Npgsql provider on the server that's hosting the data gateway (https://www.nuget.org/packages/Npgsql/4.0.2)

2. Reboot the server

 

Should now be able to use the PostgreSQL data source type when creating the data source in Power BI Service.

Thanks,
Victor Rocca | www.victorrocca.com
Moderator v-yuezhe-msft
Moderator

Re: Configure Gateway to connect to PostgreSQL

@vrocca,

As your post, you would need to install Npgsql provider on the gateway machine and make sure that you have access to the postgreSQL data source on the gateway machine.

You can treat Power BI gateway as another client like Power BI Desktop. When using Power BI Desktop to connect to postgreSQL, Npgsql provider should be installed on the Desktop machine, so does the gateway.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User
Super User

Re: Configure Gateway to connect to PostgreSQL

I ran into this issue earlier this year.  I'm a little hazy on the details of the full solution, but we had to make the connection through an ODBC driver to make it work.  It was a nightmare to get running, but it worked.


   

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

Proud to be a Datanaut!


   


Highlighted
vrocca Member
Member

Re: Configure Gateway to connect to PostgreSQL

2 Things to get this to work:

 

1. Install the Npgsql provider on the server that's hosting the data gateway (https://www.nuget.org/packages/Npgsql/4.0.2)

2. Reboot the server

 

Should now be able to use the PostgreSQL data source type when creating the data source in Power BI Service.

Thanks,
Victor Rocca | www.victorrocca.com
Moderator v-yuezhe-msft
Moderator

Re: Configure Gateway to connect to PostgreSQL

@vrocca,

As your post, you would need to install Npgsql provider on the gateway machine and make sure that you have access to the postgreSQL data source on the gateway machine.

You can treat Power BI gateway as another client like Power BI Desktop. When using Power BI Desktop to connect to postgreSQL, Npgsql provider should be installed on the Desktop machine, so does the gateway.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.