CODEWITHSUNDEEP
postgresqlamazon-web-servicespowerbi-datasource
yonabout
yonabout

Reputation: 67

connect powerbi to postgres

I need to connect power bi to a postgreSQL server.

Basically 3rd party A host an online service for us with this data source as the backend. 3rd party B connected to the data source and produced power BI reports for us from this data.

We've severed ties with 3rd party B and now need to bring the reporting in house.

3rd Party A have given me connection details that look like this:

Username: u123456789
Password: pdjrntyfgshwbefgs
Database: d123456789
Host: 3rdPartyA-bi-connector.bi3xflgeewli.eu-west-1.rds.amazonaws.com
URL: postgres://u123456789:pdjrntyfgshwbefgs@3rdPartyA-bi-connector.bi3xflgeewli.eu-west-1.rds.amazonaws.com/d123456789

Which powerbi connector do I use to get at this data source? Web? Postgres?

EDIT: As per @JNevill s comment below, on the postgres connectors in PowerBi, I'm trying this: enter image description here

Then this: enter image description here

i.e. I'm using the "Host" as the server.

Is that right? Because I get an "PostgreSQL: Exception while reading from stream" error. I just want to make sure I'm using the correct strings in the connector first before I start trying to eliminate other causes (i.e. firewall / timeout settings).

Cheers

Upvotes: 0

Views: 3148

Answers (1)

yonabout
yonabout

Reputation: 67

I managed to connect to the data source and this is how I managed it by using ODBC connector instead of postgresql. Might not be appropriate for everyone.

Step 1 - Download and install the latest Postgresql ODBC driver from here: enter link description here

Step 2 - once installed, open PowerBI, GetData and choose the ODBC connector.

Step 3 - Select None as the data source, choose advanced and in the connection string, use this format:

Driver={PostgreSQL Unicode(x64)};Server=.rds.amazonaws.com;Port=5432;Database=;sslmode=require;

Worked for me.

Upvotes: 1

Related Questions