Forum Discussion
Murhadiyanto
6 years agoFrequent Visitor
Failed to update data source credentials for postgreSQL server in PowerBI Service
The full error message is :Failed to update data source credentials: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly ...
Murhadiyanto
6 years agoFrequent Visitor
v-lid-msft
6 years agoCommunity Support
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,