Forum Discussion

mohittimpus's avatar
mohittimpus
Helper V
4 years ago

Direct Query Connection error via PostgreSQL in Power BI services

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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-is-invalid-according-to-the-validation-procedure

 

Similar threadS:

https://community.powerbi.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validation/m-p/531475

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's avatar
mohittimpus
Helper V
4 years ago

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.