Error Configure Postgres database credentials in Power BI Service

[Haidann]

I have connected Power BI Desktop with Postgres using Direct Query mode, But when I publish it to Power BI Service. I'm unable to set data source credentials for scheduled refresh. I'm getting below error:

"Failed to Update data source credentials. An error happened while reading from the provider. The remote certificate is invalid according to valdation procedure." The same credentials works fine when connect with Power BI Desktop. Please find the screenshot of the error attached below:

Error in Report

Can you guys show me step by step how to fix this error?
Many thanks

[v-eqin-msft · Accepted solution]

Hi @Haidann ,

As @lbendlin  said,please "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.

Please take a look at these issues for reference.

https://community.powerbi.com/t5/Service/Gateway-error-connecting-to-PostgreSQL/td-p/963650https://stackoverflow.com/questions/34020719/installing-ngpsql-to-use-postgresql-in-powerbi

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.

[lbendlin]

Step 1: "Install Npgsql version 4.0.10.0 or earlier"  on your gateway cluster members.