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,...
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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

         

        Thank you.  I am now trying to "get data" through "PostgreSQL database" route, hence i uninstalled my previous versions of npgsql and reinstalled npgsql and this time it allowed me to enter my server detail and database detail, unfortunately, the next step gave the below error:

         

        Any help on how to troubleshoot the below error:

         

        Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.'"

         

        Thanks

        Sheeba