PostgreSQL connection Via Power BI Service

[Lemi]

Hello,
I have a Power BI report in which i am using PostgreSql source. but i cant set up connection in Power BI Service. 
In desktop it works fine.
In Service it writes me this:

and i have installed the Npgsql and still gives me this error.
please help

[Anonymous]

Hi @Lemi ,
We haven't heard back from you regarding our last response and wanted to check in on your situation.If it sorted,
please share the solution in detail and consider to accept it as solution so that it will help other members find it more quickly.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @Lemi ,

Glad that your query has been resolved after helpful response provided by @lbendlin . If  it  addressed your question, If it helps, please give us Kudos and consider Accept it as a solution and click YES to help the other members find it more quickly.

Thank you for being a part of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @Lemi ,

I just wanted to kindly follow up and check if your query has been resolved. Please let us know if everything is sorted, and feel free to reach out if  needed further assistance. If the issue is resolved, kindly accept it as solution so that it will help other members in the community to find it more quickly.

Thank you for being a part of Microsoft Fabric Communty Forum!

[Lemi · Accepted solution]

Hello,  
I could not solve this. but using ODBC Driver and VPN Connection it works. So solution is to make some virtual machine on which gateway will run basically. I don't know any other way

[Anonymous]

Hi @Lemi ,
Thank you for the response.
Glad that it works with ODBC Driver and VPN Connection.Please share the solution in detail and consider to accept it as solution so that it will help other members find it more quickly.

Thank you for being a part of Microsoft Fabric Community Forum!

[Anonymous]

Hi @Lemi ,

Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you're experiencing.

Providing you a few points which might assist you in resolving the error :

1.Ensure that the On-Premises Data Gateway is configured properly and verify that the gateway is up and running.
2.In Power BI Desktop, go to Transform Data > Data Source Settings and check the credentials, server name, and database name details that are entered correctly in Power BI Service.
3.Update the Gateway to the latest version.
4.Ckeck if there are any firewall or network issues preventing Power BI Service from accessing your PostgreSQL database.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[Lemi]

it automatically selects Cloud Connection

I also use VPN to connect via Power BI Desktop, but it should not matter with cloud yes?

but it writes me this.
I use same credentials in my power bi desktop and it  works

[lbendlin]

Where did you install it? On all gateway cluster members?

[Lemi]

I just install it. what i should do different?
Downloaded 

and installed . then did this

with this steps. but Power BI Still writes this:

@lbendlin @Anonymous 

[lbendlin]

We used the regular 4.0.9 driver from the Power BI Desktop.  I would recommend you do the same.

[Lemi]

From where i can install that version?

[lbendlin]

you borrow it from the desktop install. 

Copy the npgsql files from 

C:\Program Files\Microsoft Power BI Desktop\bin\ADO.NET Providers

(on the desktop)  

to 

C:\Program Files\On-premises data gateway\m\ADO.NET Providers

on each of the gateway cluster members

[Lemi]

I have no  C:\Program Files\Microsoft Power BI Desktop\

[lbendlin]

You have that on your PC, not on the gateway VMs.