Forum Discussion

Pan_Forex's avatar
Pan_Forex
Helper III
2 years ago
Solved

Connect postgresql database on the private NAS server and the powerbi

Hello, I think I've searched the entire internet on this topic and I'm out of ideas. Is there any way to connect powerbi service to the postgresql database on my private NAS server? The problem is th...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Mostly correct.  The "on server"  part needs qualification. You can install the gateway on any on-prem machine but usually it is installed on a dedicated VM in the on-prem cloud.

     

    local = on-prem

  • lbendlin's avatar
    lbendlin
    2 years ago

    - install Power BI Desktop (can be on your PC)

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

    - grab the Npgsql.config file and the Npgsql folder

    - on the machine where you installed the gateway go to C:\Program Files\On-premises data gateway\m\ADO.NET Providers

    - paste the file and folder there

    - restart the gateway service

lbendlin's avatar
lbendlin
Super User
2 years ago

You need to install a Personal Gateway  (you can try to do that on the NAS server too but it is HIGHLY discouraged to have the gateway share resources with other apps).  You also need to manually copy the npgsql ADO drivers from Desktop to gateway, as there is currently a bug (installer files missing).

  • Pan_Forex's avatar
    Pan_Forex
    Helper III
    2 years ago

    I will ask the question in a different way. Is it possible to connect powerbi service to local postgre database only by using gateway installed on server?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Mostly correct.  The "on server"  part needs qualification. You can install the gateway on any on-prem machine but usually it is installed on a dedicated VM in the on-prem cloud.

       

      local = on-prem

      • Pan_Forex's avatar
        Pan_Forex
        Helper III
        2 years ago

        I did everything from the very beginning according to your instructions. I connected powerbi desktop to local postgre database 192.168.0.127:5678, loaded the data, saved and published.It says I don't need a gateway because the database is in the cloud and not locally. Any ideas on how to change this?

  • Pan_Forex's avatar
    Pan_Forex
    Helper III
    2 years ago

    Could you please explain in detail :"You also need to manually copy the npgsql ADO drivers from Desktop to gateway..."? I get the message in powerbi service all the time: Install Npgsql product version 4.0.10.0 or earlier.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      - install Power BI Desktop (can be on your PC)

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

      - grab the Npgsql.config file and the Npgsql folder

      - on the machine where you installed the gateway go to C:\Program Files\On-premises data gateway\m\ADO.NET Providers

      - paste the file and folder there

      - restart the gateway service