PowerShell Cmdlets for On-premises data gateway management

Welcome to the PowerShell reference for the On-premises data gateway. Here you will find resources for PowerShell modules for managing On-premises data gateway and also Power BI data sources.

Supported environments and PowerShell versions

PowerShell Core 6.2.2 or higher

Installation

The cmdlets are available on PowerShell Gallery and can be installed in an elevated PowerShell session:

Install-Module -Name DataGateway

Uninstall

If you want to uninstall all the Power BI PowerShell cmdlets, run the following in an elevated PowerShell session:

Get-Module DataGateway* -ListAvailable | Uninstall-Module -Force

Usage

Two scopes are supported by cmdlets :

  • Individual is used to access entities that belong to the current user.
  • Organization is used to access entities across the entire tenant. Only Power BI service admins or the O365 global admins are allowed to use this option.

Only the following cmdlets support the scope of Organization:

  • Add-DataGatewayClusterUser
  • Remove-DataGatewayClusterUser