Connect to Postgres for live data

[Anonymous]

Hi,
I wanted to connect to postgres DB from Power BI. I shoud be able to get live data from postgres. When I am trying to connect to Postgres db, I am getting the following error:

An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.

Any suggestions to get live data from postgres db to power BI would be helpful.

Thanks in advance.

[lbendlin · Accepted solution]

Live connection is not supported, only Direct Query or Import mode.

Power Query PostgreSQL connector - Power Query | Microsoft Learn