PostgreSQL ODBC driver for Power BI

  1. Download PostgreSQL ODBC drivers for both 32 AND 64 bit form https://www.postgresql.org/ftp/odbc/versions/msi/

  2. Install psqlodbc_10_01_0000-x64.zip AND psqlodbc_10_01_0000-x86.zip

  3. Open ODBC Data Source administration for 64bit platform, switch to "System DSN" tab

    images/download/attachments/160480468/image2018-11-16_8-22-29.png



  4. Add a new source, select PostgreSQL Unicode (x64).

    images/download/attachments/160480468/ODBC_PostgreSQL_driver.png

  5. Enter database server:

    If you want to test connection you have to set all fields.
    Database, server and username with password could be defined later in Power BI.
    Default database name is SQDB6 or SQDB6_DWH. The namedependson selected database deployment scenario.

    images/download/attachments/160480468/ODBC_PostgreSQL_settings.png



  6. Optional: Test connection.

  7. Save

  8. Repeat steps 3 to 8 for 32 bit ODBC Data Source as well

    1. use exactly the same name,

    2. choose PostgreSQL Unicode driver.

  9. Once completed, the "System DSN" tab looks as follows:

    images/download/attachments/160480468/image2018-11-16_8-28-42.png



Alternative Configuration Method:

  1. Download PostgreSQL ODBC drivers for both 32 AND 64 bit form https://www.postgresql.org/ftp/odbc/versions/msi/

  2. Install psqlodbc_10_01_0000-x64.zip AND psqlodbc_10_01_0000-x86.zip

  3. images/wiki.ysoft.local/s/en_GB/7502/85262de2dab440f060366aadca149a69d65c1f59/_/images/icons/emoticons/warning.png Adjust variables $dbServer and $db to point to database server and refer database name.

  4. Run the PowerShell script:

    $dbServer= "ysoft.safeq.db.server.local"
    $db= "SQDB6"
     
    Add-OdbcDsn-Name"YSoft SafeQ"-DriverName"PostgreSQL Unicode"-DsnType"System"-Platform"32-bit"-SetPropertyValue@("Server=$dbServer", "Trusted_Connection=Yes", "Database=$db")
    Add-OdbcDsn-Name"YSoft SafeQ"-DriverName"PostgreSQL Unicode(x64)"-DsnType"System"-Platform"64-bit"-SetPropertyValue@("Server=$dbServer", "Trusted_Connection=Yes", "Database=$db")