Skip to main content
Microsoft Idea

Power BI

New

Add-DataGatewayClusterMember to the PowerBI Gateway PowerShell Cmdlets

Vote (36) Share
Mykhailo Chalyi's profile image

Mykhailo Chalyi on 25 Aug 2021 11:04:40

Right now it seems to be impossible to join gateway to existing cluster, this makes it hard to automate high-available installations of PowerBI Gateway.



Use case: have 2+ instances of PowerBI Gateway machines to handle requests from PowerBI.



Currently, it is possible to join PowerBI Gateway to cluster only via configuration UI and this is not working for automation.

Comments (5)
Mykhailo Chalyi's profile image Profile Picture

Jason Welch on 06 Oct 2023 08:59:48

RE: Add-DataGatewayClusterMember to the PowerBI Gateway PowerShell Cmdlets

Infrastructure as Code for everything ...... except PBI gateway clusters, what a(nother) massive own-goal, Microsoft.

Mykhailo Chalyi's profile image Profile Picture

Chirag Pareek on 07 Jul 2023 09:12:55

RE: Add-DataGatewayClusterMember to the PowerBI Gateway PowerShell Cmdlets

shocked that this is not available and not possible still in 2023, you have raised it in 2021!

Mykhailo Chalyi's profile image Profile Picture

Trutz-Sebastian Stephani on 27 Apr 2023 15:12:29

RE: Add-DataGatewayClusterMember to the PowerBI Gateway PowerShell Cmdlets

Would be great to see some advancement on this: Automation of Power BI Gateway Server Administrati... - Microsoft Power BI Community

Mykhailo Chalyi's profile image Profile Picture

Samuel Fursdon on 01 Sep 2022 00:45:34

RE: Add-DataGatewayClusterMember to the PowerBI Gateway PowerShell Cmdlets

Similarly disappointed this isn't available. To the extent that these Powershell cmdlets are intended to offer automation, much of that value is negated by the fact they only allow the automated installation of the very first gateway and cluster combination. Even outside the HA use case of deploying multiple gateways, being able to recover a single gateway is not currently possible. For enterprise's with data sources in Clouds (other than Azure), Gateways deployed within these clouds are essential to ensuring secure access to these data sources for the same reason such gateways are required on premises. Many organisations maintain a policy of only accepting automated deployments to these cloud environments, and the lack of this feature is a deal breaker for this.

Mykhailo Chalyi's profile image Profile Picture

Rich L on 02 Dec 2021 20:39:12

RE: Add-DataGatewayClusterMember to the PowerBI Gateway PowerShell Cmdlets

I'm shocked the modules don't allow for this to happen. I recently deployed 6 clusters to different environments wrote some pretty cool automation for install and to learn that it's not possible to join some of the instances to the appropriate cluster.