Failed to update data source credentials for postgreSQL server in PowerBI Service

Hi Murhadiyanto ,

Sorry for late reply, we have reproduced this same issue. Based on this Document , It is required to install a On-Premises Data Gateway in a machine can access the PostgreSQL . And we need install client software for this provider in the machine contain the gateway. Please visit the following site and choose the 64-bit (x64) version of, at minimum, 'Npgsql version 2.0.12': https://go.microsoft.com/fwlink/?LinkID=282716

You can get more information about connecting PostgreSQL using gateway from these thereads: 

https://community.powerbi.com/t5/Desktop/Not-able-to-connect-Postgres-SQL-database-from-Power-BI/m-p/663990#M319229

https://community.powerbi.com/t5/Power-Query/Configure-Gateway-to-connect-to-PostgreSQL/td-p/478150

Best regards,

v-lid-msft 

Hi,

I am facing same issue there. I disable Encrypts Connection in PBI Desktop then publish to Power BI Cloud.

Connection on PBI Desktop is ok but PBI Cloud. It seems PBI Cloud is enabling Encrypts Connection option. Is there any way/option that I can disable Encrypts Connection on PBI Cloud?

Thanks,

Hi quangdatnth ,

Have you tried to Configured an on-premises data gateway to connect the postgreSQL in Power BI Service? Here is a document about the requirement of gateway for each kind of data source: https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources. Please refer to this document about the On-Premises Data Gateway. 

Best regards,

Hi quangdatnth , Murhadiyanto ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

Hi v-lid-msft ,

Sorry for my late reply.

I used aws rds postgresql then Power BI Cloud do not accept to enable Data Gateway:

I able to connect powerbi desktop  to aws postgresql. But when I publish to Power BI Cloud. It thrown error.

Any idea?

Appreciate your support.