PowerBI Desktop Connection Error:
Issue: When connecting to Data Store using the PowerBI (Desktop) PostreSQL database connector, I get this error:
We encountered an error while trying to connect.
Details: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"
Solution:
- In PowerBI, navigate to, File > Options and settings > Data source settings
- Select the data source then click Edit Permissions
- Uncheck the Encrypt Connections option.
There are alternative solutions listed in this stackoverflow question: 
PowerBI Web / Cloud Connection Error:
Issue:
When connecting to Data Store using the PowerBI (Web) PostreSQL database connector, I get this error:
Failed to update data source credentials:
An error happened while reading data from the provider:
'The remote certificate is invalid according to the validation procedure.'
Solution:
- In PowerBI (Web), navigate to, Settings > Manage connections and gateways
- Select the Connection and set the General > Encrypted connection setting to Not encrypted.
Related to