https://community.fabric.microsoft.com/t5/Developer/Connect-to-Postgres-for-live-data/m-p/3764689#M50443 <P>Live connection is not supported, only Direct Query or Import mode.</P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/power-query/connectors/postgresql#capabilities-supported" target="_blank">Power Query PostgreSQL connector - Power Query | Microsoft Learn</A></P> Fri, 15 Mar 2024 00:04:09 GMT lbendlin 2024-03-15T00:04:09Z https://community.fabric.microsoft.com/t5/Developer/Connect-to-Postgres-for-live-data/m-p/3762592#M50420 <P>Hi,<BR />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:</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Any suggestions to get live data from postgres db to power BI would be helpful.</P><P>&nbsp;</P><P>Thanks in advance.</P> Thu, 14 Mar 2024 07:07:11 GMT https://community.fabric.microsoft.com/t5/Developer/Connect-to-Postgres-for-live-data/m-p/3762592#M50420 Anonymous 2024-03-14T07:07:11Z https://community.fabric.microsoft.com/t5/Developer/Connect-to-Postgres-for-live-data/m-p/3764689#M50443 <P>Live connection is not supported, only Direct Query or Import mode.</P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/power-query/connectors/postgresql#capabilities-supported" target="_blank">Power Query PostgreSQL connector - Power Query | Microsoft Learn</A></P> Fri, 15 Mar 2024 00:04:09 GMT https://community.fabric.microsoft.com/t5/Developer/Connect-to-Postgres-for-live-data/m-p/3764689#M50443 lbendlin 2024-03-15T00:04:09Z