Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Postgres to PowerBI connection through ODBC

Hi,

I am trying to connect Postgres(cloud server) to Power BI, I initially downloaded 64 bit PSQLODBC server got the below error and then i uninstalled 64 bit and reinstalled 32 bit PSQLODBC server, still getting the same error

 

Details: "ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found.

 

Can anyone help to fix this issue and get it working.... 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous ,

    I'd like to suggest you contact the author of 'npgsql' and report this issue and waiting for compatibility update or try to use old version 'npgsql'.

    Regards,

    XIaoxin Sheng

5 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi, first of all, where is this postgres? because if it's on aws we have a problem, you need some configurations on your machine certificates. When you add the odbc configuration, is the test connection working? you didn't specify is the problem is connecting  power bi or the odbc. In case odbc windows configuration is not working, can you show how are you connecting so we can help?

     

    Other thing, did you try the Postgres Connector instead of odbc?

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Ibarrau,

       

      Thanks for your response.

      Postgres is in Google cloud.  I tested the ODBC test connection and the message displayed as test successful. When i try to connect Power BI with ODBC then i get the below error.

       

       Details: "ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (PostgreSQL ANSI, C:\Program Files\Tableau\Drivers\psqlODBC\0906\bin\psqlodbc30a.dll)."

       

      i tried to connect the database through postgres directly, i downloaded npgsql-4.1.1 but still did not connect.

       

      So both the ways i was unsuccessful in connecting to the postgres DB. Please help

       

      Thanks & Regards,

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Anonymous ,

        According to your error message, it seems like more related to your odbc driver configure and library, please double-check on your software environment to confirm they compatible with power bi connector.
        Regards,

        Xiaoxin Sheng