On-prem data gateway

[ggbae]

Hi,

I have a report in Power BI service that is connected to a SSAS tabular model (live connection). The gateway connection was configured by a former employee. Using the same data source, I created a report and published it but it looks like I need to set up a new gateway connection because its not recognizing the built-in connection configured by the former employee.

If I set up a new gateway connection, is it going to impact the one already in place? Like can we have two diferent gateways set up by two different users on the same data source? Please help me clarify.

[Tutu_in_YYC]

Hi ggbae, 

I dont think you need to create a new gateway, instead, try to get access to use the configured gateway. And i dont think you can install 2 gateways in one machine anyway.

If you not able to do that ( due to the former employee is gone and dont have the credential to go in and manage the gateway), then ouff.. you may need to delete that gateway in the machine and reinstall. Very risky though.

If you are able to reinstall gateway, consider using service account so that it can be taken over by another user.

[ggbae]

Thank you for your response.

I tried using the gateway connection set up by the former employee but it does not show up. Cannot I just create a new gateway connection and use that gateway to add the data source for my report keeping the one set up by the former employee intact?

[Tutu_in_YYC · Accepted solution]

One computer/server/machine can only have 1 gateway. So I dont think you can install a new gateway ( but you can install another gateway in a separate machine that is connected in the same network as the machine that has the datasource)

To add a connection within an existing gateway, you need to be an admin of the gateway. If the former employee has given you the access to admin the gateway, then you can set up another connection.

Just to summarize, setting up gateway is a 2 step process:
1- install gateway in machine

2- set up datasource connection in the gateway