Forum Discussion
Configure Gateway to connect to PostgreSQL
2 Things to get this to work:
1. Install the Npgsql provider on the server that's hosting the data gateway (https://www.nuget.org/packages/Npgsql/4.0.2)
2. Reboot the server
Should now be able to use the PostgreSQL data source type when creating the data source in Power BI Service.
vrocca,
As your post, you would need to install Npgsql provider on the gateway machine and make sure that you have access to the postgreSQL data source on the gateway machine.
You can treat Power BI gateway as another client like Power BI Desktop. When using Power BI Desktop to connect to postgreSQL, Npgsql provider should be installed on the Desktop machine, so does the gateway.
Regards,
Lydia
hi, i have the same problem, but i have installed npgsql 4xxx 3xxx and 2xxx, and continue no solution, my power bi desktop connect normaly to postgress db, but o gateway no, sollutions? thnks
I also had the same error problem. Starting from November 7, 2019 an error occurred. History does not have this error.
Thanks for your supportSame here the error start 14/11/2019
I've solved the problem installing Npgsql 4.0.10 WITH GAC(!!!)
When installing, make sure that you select NpgSQL GAC Installation.
This GAC did the trick.
Then reboot the machine.
Good luck!
