Skip to content

Instantly share code, notes, and snippets.

@win2000b

win2000b/PowerBIGatewayStatus.ps1

Created July 17, 2019 08:12
Show Gist options
  • Save win2000b/15b850b55588714fc2692ed4009f3583 to your computer and use it in GitHub Desktop.
Save win2000b/15b850b55588714fc2692ed4009f3583 to your computer and use it in GitHub Desktop.
Download ZIP
Check Power BI Cluster Node Status
Raw
PowerBIGatewayStatus.ps1
# Open Elevated PowerShell. Change into Gateway Directory
cd 'C:\Program Files\On-premises data gateway\'
# Set Execution Policy
Set-ExecutionPolicy -ExecutionPolicy Unrestricted -Force
# Import Gateway PowerShell Module
Import-Module .\OnPremisesDataGatewayHAMgmt.psm1
# Login as PowerBI Administrator
Login-OnPremisesDataGateway
# Get a list of all Gateway Clusters
Get-OnPremisesDataGatewayClusters | ft
# Query the status of the cluster you are interested in.
Get-OnPremisesDataClusterGateways -ClusterObjectId 0111111-11111-1111-1111-1111175e929
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment