Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
juanca
Helper II
Helper II

PostgreSQL connection through On-premise Data Gateway

Hi everyone,

I need to connect my app.powerbi.com to a PostgreSQL database. I have an on-premise data gateway installed on my computer (the computer where I have my PowerBI Desktop and my report design, etc.).

The issue is that when I try to set the PostgreSQL origin in the Gateway Configuration in app.powerbi.com, the specific option for this database doesn't exist.

Could I set the PostgreSQL origin through another origin (i.e. SQL Server or MySQL) ? If this is not possible, which is the alternative?

Thanks a lot,
Kind regards.

1 ACCEPTED SOLUTION

Hello,

for ODBC connection to postgres you need to get installed ODBC driver for postgres;i am using PostgresSQL Unicode(x64).

After that you have 2 options:

1) create user DSN via ODBC data source administrator (C:\Windows\System32\odbcad32.exe). In that case the connection string for ODBC data source is "dsn=dsn_name" where dsn_name represents the user dsn created via tool above

2) alternative option for connection string is: driver={PostgreSQL Unicode(x64)};server=server_name;port=5432;database=db_name

where server_name represents a server name or its IP, db_name is name of database.

For using on-premise gateway you need to use ODBC connection to postgress on power bi desktop. Then you need to configure data sources using ODBC the same way on on-premise gateway.

 

I am using above approach for connection to multiple different postgres databases.

I hope it helps.

 

Kind regards

M

View solution in original post

12 REPLIES 12

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.