When connecting to Datastore using the PowerBI 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 go to File / Options and settings / Data source settings
then select the data source and Edit Permissions and uncheck encrypt connections
There are alternative solutions listed in this stackoverflow question: 