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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TWMY1014
Resolver I
Resolver I

Unable to connect connection credential in Power BI server from Postgres

Hi All,

 

I have a postgres as key data source, and had download on-premises data gateway (personal mode) with aim to schedule refresh the data.

I do have username and password in Postgres, but when I try update data source in data gateway in Power BI server, it keep fail.  I try to create a new source but have identical message in below

TWMY1014_0-1716653441774.png

Thanks.

 

Regards,

Thomas

 

1 ACCEPTED SOLUTION
TWMY1014
Resolver I
Resolver I

Thanks lbendin.

I finally create ODBC driver for Postgres and adjust desktop data source directly from Postgres to ODBC.  Then on-premises data gateway can connect with ODBC for schedule refresh.

View solution in original post

5 REPLIES 5
TWMY1014
Resolver I
Resolver I

Thanks lbendin.

I finally create ODBC driver for Postgres and adjust desktop data source directly from Postgres to ODBC.  Then on-premises data gateway can connect with ODBC for schedule refresh.

Invest the time to install the native driver. It should have better performance.

Thanks Ibendlin.
You mean to let on-premises data gateway directly connect with Postgres to complete the schedule refresh task ? Do I add data source (Postgres) at data gateway (I don't know which folder I should locate to in Connector field, is it the folder where Postgres was locate ?) or at Power bi server (I try create a new data source but somehow throwing the error message in initial post) ?

Thanks.

None of the above.  You would need to install the PostGres driver on all gateway cluster members. Either borrow the driver from Power BI Desktop or install the driver from the PostGres site.

lbendlin
Super User
Super User

PostGreSQL drivers are not installed by default on the gateway. You need to add these manually.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors