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

     

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