Forum Discussion
Solved
Error Configure Postgres database credentials in Power BI Service
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 ...
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.