Forum Discussion

bavix's avatar
bavix
Frequent Visitor
5 years ago
Solved

Error DataSource.MissingClientLibrary PostgreSQL gateway

After installing the gateway we installed Npgsql 4.0.10 with GAC we still get the following error. How to get this solved?  
Need Help
  • bavix's avatar
    bavix
    5 years ago

    Thank you very much for the support.

    With your suggestions we checked it all again. And now we succeeded.

ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. I remember a problem like this some time ago. We realized that the Gateway won't take any driver for connection until you restart the VM or PC. You can try connecting with Power Bi Desktop from that VM/PC to test the connection too.

Hope that helps,

  • bavix's avatar
    bavix
    Frequent Visitor
    5 years ago

    Hi Ibarrau. Thanks.

    How can I try to connecting within PBI desktop, what datasource do I need to select to test the connection?
    I get data from the PostgreSQL database and this works ok on the vm desktop. Publishing from this vm also works ok. But the automatic refresh in the service needs to go via a gateway where I get the error.

     

    • ibarrau's avatar
      ibarrau
      Super User
      5 years ago

      Sometimes the Power BI Desktop is used from a different VM than the Gateway VM. I was saying that you can install Desktop in the same VM of the gateway to test that postgres connection. Just get data from the postgres you want to refresh and see if it returns data. Don't forget to restart the Gateway VM.

      Regards,

      • bavix's avatar
        bavix
        Frequent Visitor
        5 years ago

        We checked the software on all servers. We now get a DataSource.Error

        Any suggestion?