How can we automate the install of Gateway using command line or powershell?

[trevorgermain]

There doesn't appear to be a way for our DevOps team to control the automated install of the Gateway. I've tried command line, attempted using the common /? and -h switches to get command line args list.

This is a requirement from an enterprise perspective. How do we automate the Gateway install?

[Seth_C_Bauer]

@trevorgermainThis thread seems to be what you are looking for.

[trevorgermain]

Actually, that thread has to do with configuring and using Gateways via the REST Api. It doesn't address actually installing and configuring the .exe on the Windows' Server.

Our DevOps team are going to want to run a powershell or command line version of the gateway installer, including setting paths, recovery passwords, etc. in an automated way.

[v-huizhn-msft]

Hi @trevorgermain,

As I tested, you can start the gateway exe using powershell and install it. But you need to configure it(account permisson and connect it to power bi service) if you want to use, which is related to the design of gateway. And there no clear document to describe the structure of gateway. You can create a support ticket to consult here.

Best Regards,
Angelia

[trevorgermain]

You were able to install the gateway using PowerShell with no UI prompts? How did you do that? What exact command did you do?

[catcollector]

@trevorgermain 

We were able to run the following script to install the Gateway. However, I think I am after similar information as you. This script fetches the .exe and installs the Gateway. In the case, where a Gateway is already installed, we can re-execute the script but it would run an update. At this point, a wizard shows up and we have to click through for the update. I'm looking for a way to "force" through the wizard for updates going forward (for lack of better term). I'm curious whether anyone has been able to accomplish this?

$power_bi_gate_install_url ="https://download.microsoft.com/download/D/A/1/DA1FDDB8-6DA8-4F50-B4D0-18019591E182/GatewayInstall.ex..."
$power_bi_gate_download_path="$PSScriptRoot\GatewayInstall.exe"

#Installing Power BI Gateway
Write-Output "Installing Power BI GateWay =" $power_bi_gate_install_url
Invoke-WebRequest -Uri $power_bi_gate_install_url -OutFile $power_bi_gate_download_path
Write-Output "Initiating Install for Power BI Gtwy"
Start-Process -filepath $power_bi_gate_download_path -ArgumentList "/qb /norestart" -Wait

Thank you.