Forum Discussion

A48skzz's avatar
A48skzz
Frequent Visitor
5 years ago
Solved

On-premises data gateway multiple users

Hi all,   i use the standard on-premised data gateway (not personal) for my connection to Terradata DB. As long as I'm connected with my companies network the dataset refresh is running correctly....
ok
  • Icey's avatar
    Icey
    5 years ago

    Hi A48skzz ,

     

    Based on your requirement, what you want is to create another gateway in your gateway cluster, not just add another Administrator.

    A cluster lets gateway admins avoid having a single point of failure for on-premises data access. If the primary gateway is unavailable, data requests are routed to the second gateway that you add, and so on.

     

    Reference: What the HECK is a Power BI Gateway Cluster? | Guy in a Cube

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Super User
5 years ago

That's not how gateways work.  Gateway cluster members are (mostly) VMs in you on-premise compute cloud that act as a stand-in for your Power BI Desktop mashup engine.

 

If your gateway only has one cluster member (your PC) then it will stop working when that single cluster member is not able to talk to the Azure cloud to get refresh orders.

 

To be clear: The gateway definition in the Power BI service is just that - a definition. It has nothing to do with the physical availability of the gateway cluster members.

 

Install another gateway cluster member or two on a machine that is in your company network, and is always on. Then remove your PC's gateway cluster member from the gateway. (You need to switch anchors too).

 

You need to use Powershell for the removal.