Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Can you guys show me step by step how to fix this error?
Many thanks
Solved! Go to 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.
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.
Step 1: "Install Npgsql version 4.0.10.0 or earlier" on your gateway cluster members.