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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
LD8219
Frequent Visitor

Datamart can't connect PostgresSQL Database

Hello guys, I can't establish the connection of my Datamart with a DB in Postgres SQL that is in an external server.
Could you help me

3 REPLIES 3
LD8219
Frequent Visitor

When I try to connect to data source this is the error that trow me, I don't know if i need make an extra configuration on the the DB server or not, I have stablished the connection from de PBI Desktop to this DataBase of PostgresSQL without proble, but when I try to connect from Datamart it Happend.

 

Connection filed.PNG

amitchandak
Super User
Super User

@LD8219 , If external means cloud then make sure the ip whitelisting is not needed, if needed refer

https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls

 

If external means a datacenter, not a cloud, you might need an on-premise gateway.

 

Also check need of SSL

Hello Amitchandak thanks por answered, the Database that I want to access from my Datamart is mounted on an external server in Postgres SQL, it is not in the cloud, I do not have administrative permissions on said server, but through my power BI Desktop I can access the database with user and pass and import its tables to build my reports.
From the browser, once I create my Datamart, when I go to obtain the tables of said Database, it throws me the error of the image in the comment below.
The only way to access this data from the Datamart is with an on-premise gateway.??

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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