Postgres on AWS RDS + gateway (personal mode)?

[peivol]

Hi all,

We have set a postgresql hosted on AWS RDS connection to the power BI app (steps here). We have power BI and an On-premise data gateway working on an EC2 instance. It has worked correctly (for a year) and we can refresh data on the app.

A Data Scientist created recently a dashboard with a python script for some transformations and visuals. We installed the data gateway (personal mode) on the instance. The problem is that when trying to connect the postgresql on cloud it throws the "certificates error":

The remote certificate is invalid according to the validation procedure.

Since the On-premise data gateway works, the personal gateway should work too. Or am I missing something?

[aj1973]

Hi @peivol 

You installed another Gateway (Personal) on the same instance? You should have uninstalled the old one then!

A machine can't have 2 Gateways installed at once.

[peivol]

Hi Amine, thanks for your response!

We have an installation for On-premise data gateway (standar) and another for On-premise data gateway (personal mode). Theoretically, having both (different) on-premis data gateways on the same instance should work.

I have tried to uninstall and re-install the personal mode, but it stills throws the error.

[aj1973]

I wonder why using the personal Gateway if the standard is working fine and it is not for clustering !

Did you add the personal Gateway in the service? Did you allow self using it? Is the use of a Personal Gateway allowed by the Tenant Admin? 

Can you screenshot the Gateway connectio of the dataset please?

[peivol]

Thank you! let me give a bir more of context:

The problem is that we are trying to use Python on power BI. We found (here) that it needs the On-premise data gateway (personal mode) to run schedule refresh of the data.

We have set it as a personal gateway with a cloud connection to the RDS. Apparently, it cannot load the RDS data from the Standar gateway and the python scripts from the personal gateway (see below).

Note: on the image appears as desktop because I'm testing the gateway on my local machine.

Looking deeper after your message. It seems like the connection on postgresql is not set on personal mode. For python was set automatically, but for the postgresql connection the cluster request to be the On Premise gateway?

Might it be a missing configuration?

[aj1973]

That's what I meant by clustering

Hence I doubt that could be the case when you have 2 Gateways in the same machine for the same Dataset.

What you can do though is;  you can create 2 seperate Datasets, one for your Py script and the other one without it. Publish them and use one Gateway for each of them to schedule refresh. Once done, Open Desktop and build a composite semantic model from both Datasets, and build your report.

What it could be even better is to create a Dataflow, but I am not sure if the Py script will run in Power Query Online! if it works then you are all set to build your semantic model and report on top of it. This way the dataflow is the unique source of truth with one schedule refresh configured.

Please let me know either way.