Forum Discussion

tousinn's avatar
tousinn
Regular Visitor
3 years ago

How to remove the Power BI gateway using PowerShell or REST API

Hi team   We are trying to delete Power BI gateway by using PowerShell module or REST API.   We tried to use DataGateway PowerShell module to get the gateway first and remove it using the comdlet...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

If you must - there is a choreography to it.

 

1. List all gateways and all cluster members

2. Identify the anchor member

3. for each gateway, remove the members that are NOT the anchor

4. remove the anchor member.

 

Hint:  The gatewayObjectId of the anchor member is the clusterObjectID

 

Note:  This only removes the meta data on the Power BI Service. It does not do anything to your VMs.

tousinn's avatar
tousinn
Regular Visitor
3 years ago

Thanks lbendlin 

 

Does this mean we still could only remove the members from the gateway?

 

I am trying to remove the gateway itself by using PowerShell or REST API using Service Principal.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    When you remove the anchor member the entire gateway registration will be gone and all connections on that gateway too.

    • tousinn's avatar
      tousinn
      Regular Visitor
      3 years ago

      Hi lbendlin 

       

      Thanks for the replies.

       

      May I know what the anchor member is here?

       

      We only have the Azure Service Principal Assigned to the Gateway, which is the admin for the gateway as well.

       

      Is the Azure Service Principal the anchor member in this case?

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        The anchor member is the primary VM registered as a gateway in a gateway cluster.  It is a machine identifier, not a login identifier.