cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AGUS
Regular Visitor

Connect postgreSQL to power BI web

Hi!

 

I was able to connect PowerBI to Postgres on Desktop, but when I view it in the web/cloud verison it gives me the error: "Failed to update data source credentials:  The PostgreSQL source doesn't support encrypted connections."

 

I'm already using a gateway with my PC and it works with connection with MySQL.

 

How can I get the connection with PostgresSQL to work on PowerBI web?

 

Thank you.

1 ACCEPTED SOLUTION

Hi @AGUS ,

 

I am not an expert in doing it in the gateway, but this article appears to show the gateway setup.

PostgreSQL data refresh using Data Gateway in Power BI report | by Ramu Vudugula | Medium

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

4 REPLIES 4
collinq
Super User II
Super User II

Hi @AGUS ,

 

This article explains how to connect to PostgreSQL

Power Query PostgreSQL connector | Microsoft Docs




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




AGUS
Regular Visitor

Hi,

 

I have the connection at desktop level but when I upload it to Power BI web the connnetion is lost.

This is the message when I try to configure it:

AGUS_0-1620223929726.png

I don't know how to do it.

Thank you

Hi @AGUS ,

 

I am not an expert in doing it in the gateway, but this article appears to show the gateway setup.

PostgreSQL data refresh using Data Gateway in Power BI report | by Ramu Vudugula | Medium

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

AGUS
Regular Visitor

Thank you very much!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!