cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raymond
Post Patron
Post Patron

Connect PowerBI to AWS PostgreSQL using PuTTY

Hello everyone,

 

I have a rather complicated question regarding the connection to a AWS PostgreSQL and Power BI. 

 

The Database is stored on an AWS VPC. Database format is PostgreSQL. I use bastion to create the link between windows (Putty) and the linux database (AWS VPC). In my first set up the database wasnt stored on a vpc, it was rather hosted in the public internet. Power BI was easily able to establish the connection.

 

After adding the VPC, a connection could not be made. To establish this connection I am using Putty and of course the right key.

Testing with PgAdmin, I was able to connect my PC with the Database, however Power BI doesnt do so. 

 

I have no Idea why PBI cant establish a connection. There is no error code. 

Does anyone of you can help? It is kind of urgend 😄

 

6 REPLIES 6
raymond
Post Patron
Post Patron

Hi @Deep,
no we couldnt get through. Thus had to open it up; make it available w/o tunnel.

v-yuta-msft
Community Support
Community Support

@raymond,

 

No error code means time out, right? Click dataset-> Data souce credential and check if the credential is invalid or expired.

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuta-msft thanks for responding.

 

Exactly, time out which resulted in the message "could not connect to data - error in loading previous table" » this message gets displayed for each data table. 

 

We have double checked the credentials, the cterificate on my windows machine, the npgsql, the putty keys, the ports. Nothing so far. We have even tried to use multiple laptops. 

 

A connection via pgadmin was possible, the connection via powerbi not. 

It seems as if now one can really help. 

 

Meanwhile I have talked to our IT department, which was also partly involved, and they said it might be possible with another server gateway. Is there any best practice? Can still anyone help me on my issue?

Anyone here? I know simle threads are more welcome 🙂

@raymond I am also struggling with this problem. Did you solve it?

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.