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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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