Forum Discussion
Connecting to PostGreSQL on the cloud
Hi gcanelon,
Based on the above error message, the issue is related to npgsql installation. Please Download and unzip the most recent Ngpsql data provider for PostgreSQL, then use GACUtil.exe to add Mono.Security.dll to the global cache.
There is a similar article for your reference.
https://support.office.com/en-us/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4
Thanks,
Lydia Zhang
Hi. We were able to get this working directly (not via ODBC), but I am left wandering: I want to publish this to the web and have it update periodically, with a database on the cloud.
Do I need a gateway? It seems odd to need a machine inside my network to connect a thing in the cloud (BI) with another thing in the cloud (postgres).
