Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Posgresql connection not working

We have a dataset that imports from Postgresql. It works when published. It is configured to use gateway which is installed on the same machine where model was created - so npgsql package is present ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

 

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.

 

Best Regards,
Kelly

Anonymous's avatar
Anonymous
Not applicable
6 years ago

As I mentioned in the update post, npgsql version 4.1.2 is already installed on the gateway machine, and the problem remains.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Just now,I have tried to install npgsql version 4.1.2 and a lower version of npgsql, but  the problem as you mentioned remains,so pls be patient,it may need time till I find out the problem, once it get resolved ,I'll reply to you asap.

     

    Best Regards,

    Kelly

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Any updates?

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ，

         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

         

         

        Best Regards,
        Kelly