Forum Discussion
Failed to update data source credentials for postgreSQL server in PowerBI Service
Hi Murhadiyanto ,
Does the dataset use DirectQuery Mode to connect the PostgreSQL? Have you configured SSL encryption for your PostgreSQL instance? If SSL encription is not configured properly in your data source, you can go to File->Options and Settings -> Data Source Settings in Power BI Desktop, select your PostgreSQL source and unclick "Encrypt connections", then published it to the service. Please test it with a copy of this report.
Best regards,
Hi , v-lid-msft
Yes the Dataset use direct query to Postgresql , But I doesn't configure the SSL.
I'm already trying your solution but it's still got the error in my powerbi service
Regards,
Murhadiyanto
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/Power-Query/Configure-Gateway-to-connect-to-PostgreSQL/td-p/478150
Best regards,