Multiple gateways, multiple servers with 1 user.

[Anonymous]

Hi all!

I have 2 ERP system, both on premise each on a different server.

I am creating a workflow using Power Automate which takes data from the 2 systems, run a few tasks and then create a power BI  report.

How should I install the gateways?

Can I install a gateway on each server and authenticate with the same user and password?

Thank you, Tal

[Anonymous]

Power automate will send API request to the #1 ERP system, proccess the json, modify a few fields and post it to the #2 ERP (SAP buinsess One with a Hana DB)

I am sure that data gateway will be needed, my quiestion is can I install the datagate way on each of the ERP server and authenticate with the same user?

[amitchandak]

@Anonymous , I think for on-premise gateway will be needed. Power Automate is loading data service or to pbix ?

Either Power Automate or Power bi will require on premise gateway

[Anonymous]

Hi

the I will connect the gateway to Power Automate

We are not sure what will be the target of the data