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
Murhadiyanto
6 years agoFrequent Visitor
- v-lid-msft6 years agoCommunity Support
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,- Murhadiyanto6 years agoFrequent Visitor
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
- Murhadiyanto6 years agoFrequent Visitor