topic Re: Connecting to PostGreSQL on the cloud in Power Query

Connecting to PostGreSQL on the cloud

gcanelon — Fri, 10 Feb 2017 20:44:54 GMT

Hi, I am trying to connect to a PostGreSQL database that is in the cloud hosted by the Clinical Trials Collaboration Initiative.

I am trying to conduct research on clinical trials and this service provides data updated daily for researchers.

The credentials to use are (this is public information)

Hostname: aact-prod.cr4nrslb1lw7.us-east-1.rds.amazonaws.com

Port: 5432

Database name: aact

User name: aact

Password: aact

But then I get the following error:

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The system cannot find the file specified.'"

I am using PowerBi Desktop installed in Windows 10.

Any idea what might be going on?

Thanks.

Re: Connecting to PostGreSQL on the cloud

Anonymous — Mon, 13 Feb 2017 06:19:43 GMT

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.

Thanks,
Lydia Zhang

Re: Connecting to PostGreSQL on the cloud

juanpablo — Fri, 20 Oct 2017 15:15:04 GMT

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).

Re: Connecting to PostGreSQL on the cloud

hannahgrobinson — Tue, 16 May 2023 10:44:18 GMT

juanpablo gcanelon were you able to resolve this? running into the same issue now myself. thanks!