Forum Discussion

Lemi's avatar
Lemi
Frequent Visitor
1 year ago
Solved

PostgreSQL connection Via Power BI Service

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 ...
Dataflow
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Lemi's avatar
    Lemi
    1 year ago

    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

Lemi's avatar
Lemi
Frequent Visitor
1 year ago

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's avatar
lbendlin
Super User
1 year ago

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

  • Lemi's avatar
    Lemi
    Frequent Visitor
    1 year ago

    From where i can install that version?

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      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's avatar
        Lemi
        Frequent Visitor
        1 year ago

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