Forum Discussion
Postgres on AWS RDS + gateway (personal mode)?
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?
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?
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.