Direct Query Connection error via PostgreSQL in Power BI services

[mohittimpus]

Hello, my conecction works at desktop level, but when I upload it to Power BI Web it does not work.

In Desktop PostgreSQL is connect but I disable encryption from database seeting, this will give any issue. 

[v-eqin-msft]

Hi @mohittimpus ,

The installed database provider 'Npgsql' targets an incompatible .NET Framework. Please install Npgsql version 4.0.10.0 or earlier" and make sure that you select NpgSQL GAC Installation.Then restart the pc.

I found an alternative——You can connect PostgreSQL using ODBC Connection.Please kindly refer to: https://newbedev.com/an-error-happened-while-reading-data-from-the-provider-the-remote-certificate-i...

Similar threadS:

https://community.powerbi.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validati...

https://community.powerbi.com/t5/Service/Connecting-Postgres-on-AWS-from-PowerBI-Web/m-p/1064295

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mohittimpus]

But this Solution only work in Desktop level.

Problem I have when I published reprot on Power BI services account and add connection there.So that time it give this type of error. 

I connect vai direct query.