Forum Discussion

johnpjustus's avatar
johnpjustus
Helper IV
3 years ago
Solved

Dataflow connection to PostgreSQL database - Please install Npgsql version 4.0.10.0 or earlier

Hi , We have On-Premise PostgreSQL database and I am trying to connect to it through dataflow from PowerBI service. I see the following error. An exception occurred: Please install Npgsql version 4...
Dataflow
  • johnpjustus's avatar
    johnpjustus
    3 years ago

    Please ignore, I figured it out. I installed on Npgsql provider on the gateway machine and then it worked.

    Thanks

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  johnpjustus ,

 

Based on your description, it may be that the version you are currently using cannot match Power BI Service，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.

This is the related document, you can view this content:

Solved: Gateway error connecting to PostgreSQL - Microsoft Power BI Community

Solved: Error DataSource.MissingClientLibrary PostgreSQL ... - Microsoft Power BI Community

Solved: Configure Gateway to connect to PostgreSQL - Microsoft Power BI Community

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

johnpjustus's avatar
johnpjustus
Helper IV
3 years ago

Thanks Liu for the information. Do I  install Npgsql version 4.0.10.0 or earlier on the PostgreSQL database server?

But when connecting from PBI desktop to the PostgreSQL database there are no issues.

 

  • johnpjustus's avatar
    johnpjustus
    Helper IV
    3 years ago

    Please ignore, I figured it out. I installed on Npgsql provider on the gateway machine and then it worked.

    Thanks