PostgreSQL ODBC driver for Power BI
Download PostgreSQL ODBC drivers for both 32 AND 64 bit form https://www.postgresql.org/ftp/odbc/versions/msi/
Install psqlodbc_10_01_0000-x64.zip AND psqlodbc_10_01_0000-x86.zip
Open ODBC Data Source administration for 64bit platform, switch to "System DSN" tab
Add a new source, select PostgreSQL Unicode (x64).
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.Optional: Test connection.
Save
Repeat steps 3 to 8 for 32 bit ODBC Data Source as well
use exactly the same name,
choose PostgreSQL Unicode driver.
Once completed, the "System DSN" tab looks as follows:
Alternative Configuration Method:
Download PostgreSQL ODBC drivers for both 32 AND 64 bit form https://www.postgresql.org/ftp/odbc/versions/msi/
Install psqlodbc_10_01_0000-x64.zip AND psqlodbc_10_01_0000-x86.zip
Adjust variables $dbServer and $db to point to database server and refer database name.
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"
)