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 there. Dataset is configured to use this gateway.

 

However, manual or scheduled refreshes fail with the error: 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

 

 

Any tips?

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Update. Manually installing latest (4.1.2) version of npgsql, then restarting the gateway service, didn't fix the problem.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community 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
        Community 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