Forum Discussion
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 any issue.
2 Replies
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/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.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.
