Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

PowerBi desktop installation using powershell

I need some assitance with installating powerbi desktop silently on windows 10 machines using powershell script.

 

I have made a script, specified below.

 

Powershell script

#To install specific versions, update the URL variables below with links to the .msi installers.


$installerPath = "C:\Temp\install\PBIDesktopSetup_x64.exe"
$pcoipAgentUrl= "https://www.microsoft.com/en-us/download/details.aspx?id=58494"

# Start powershell logging
$SaveVerbosePreference = $VerbosePreference
$VerbosePreference = 'continue'
$VMTime = Get-Date
$LogTime = $VMTime.ToUniversalTime()
mkdir "C:\\NMWLogs\ScriptedActions\remotedesktop" -Force
Start-Transcript -Path "C:\Temp\NMWLogs\ScriptedActions\powerBi\ps_log.txt" -Append
Write-Host "################# New Script Run #################"
Write-host "Current time (UTC-0): $LogTime"

# Make directory to hold install files
mkdir "C:\Temp\install" -Force

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Invoke-WebRequest -Uri $pcoipAgentUrl -OutFile "$installerPath" -UseBasicParsing

# Install powerBi."https://www.microsoft.com/en-us/download/details.aspx?id=58494"
Write-Host "INFO: Installing powerBi. . ."
$process = Start-Process msiexec.exe -ArgumentList -silent -passive -quiet ACCEPT_EULA=1
Write-Host "INFO:powerbi install finished."

# End Logging
Stop-Transcript
$VerbosePreference=$SaveVerbosePreference.

 

The script is downloading the exe file from the websit, but not doing the installation.

 

Need guidnace on this part, how can I install it silently. 

$process = Start-Process msiexec.exe -ArgumentList -silent -passive -quiet ACCEPT_EULA=1
Write-Host "INFO:powerbi install finished."

 

Please guide me on this, or anybody else knows a different way.

3 REPLIES 3
BMallette
Regular Visitor

 

The download script suggested did not yield the expected results, as the URL "https://www.microsoft.com/en-

us/download/details.aspx?id=58494" returns a form that required user input.

 

The Download Button brings you to the following URI "https://www.microsoft.com/en-us/download/confirmation.aspx?id=58494" that can be searched through for the download URL for each files.

 

Code :

 


[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
$A = ""

## Initial link for the product
## "https://www.microsoft.com/en-us/download/details.aspx?id=58494"

## Download Page for PowerBI refered by the Download button of the previous page
$DownloadPowerBIUri = "https://www.microsoft.com/en-us/download/confirmation.aspx?id=58494"

## Get the Page content
$A = Invoke-WebRequest -Uri $DownloadPowerBIUri -UseBasicParsing

## Find the first x64 link and download the file to c:\temp
Invoke-WebRequest -Uri ( ($A.Links | ? {$_.href -like "*PBIDesktopSetup_x64.exe*" }) | Select -First 1 ).href -OutFile c:\Temp\PBIDesktopSetup_x64.exe


## Find the first x32 link and download the file to c:\temp
Invoke-WebRequest -Uri ( ($A.Links | ? {$_.href -like "*PBIDesktopSetup.exe*" }) | Select -First 1 ).href -OutFile c:\Temp\PBIDesktopSetup.exe

 

 

 

v-rzhou-msft
Community Support
Community Support

Hi @Anonymous 

Try this code to install Power BI Desktop by Power Shell.

<#
.SYNOPSIS
    This script performs the installation or uninstallation of Microsoft Power BI Desktop.
    # LICENSE #
    PowerShell App Deployment Toolkit - Provides a set of functions to perform common application deployment tasks on Windows.
    Copyright (C) 2017 - Sean Lillis, Dan Cunningham, Muhammad Mashwani, Aman Motazedian.
    This program is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
    You should have received a copy of the GNU Lesser General Public License along with this program. If not, see <http://www.gnu.org/licenses/>.
.DESCRIPTION
    The script is provided as a template to perform an install or uninstall of an application(s).
    The script either performs an "Install" deployment type or an "Uninstall" deployment type.
    The install deployment type is broken down into 3 main sections/phases: Pre-Install, Install, and Post-Install.
    The script dot-sources the AppDeployToolkitMain.ps1 script which contains the logic and functions required to install or uninstall an application.
.PARAMETER DeploymentType
    The type of deployment to perform. Default is: Install.
.PARAMETER DeployMode
    Specifies whether the installation should be run in Interactive, Silent, or NonInteractive mode. Default is: Interactive. Options: Interactive = Shows dialogs, Silent = No dialogs, NonInteractive = Very silent, i.e. no blocking apps. NonInteractive mode is automatically set if it is detected that the process is not user interactive.
.PARAMETER AllowRebootPassThru
    Allows the 3010 return code (requires restart) to be passed back to the parent process (e.g. SCCM) if detected from an installation. If 3010 is passed back to SCCM, a reboot prompt will be triggered.
.PARAMETER TerminalServerMode
    Changes to "user install mode" and back to "user execute mode" for installing/uninstalling applications for Remote Destkop Session Hosts/Citrix servers.
.PARAMETER DisableLogging
    Disables logging to file for the script. Default is: $false.
.EXAMPLE
    PowerShell.exe .\Deploy-PowerBIDesktop.ps1 -DeploymentType "Install" -DeployMode "NonInteractive"
.EXAMPLE
    PowerShell.exe .\Deploy-PowerBIDesktop.ps1 -DeploymentType "Install" -DeployMode "Silent"
.EXAMPLE
    PowerShell.exe .\Deploy-PowerBIDesktop.ps1 -DeploymentType "Install" -DeployMode "Interactive"
.EXAMPLE
    PowerShell.exe .\Deploy-PowerBIDesktop.ps1 -DeploymentType "Uninstall" -DeployMode "NonInteractive"
.EXAMPLE
    PowerShell.exe .\Deploy-PowerBIDesktop.ps1 -DeploymentType "Uninstall" -DeployMode "Silent"
.EXAMPLE
    PowerShell.exe .\Deploy-PowerBIDesktop.ps1 -DeploymentType "Uninstall" -DeployMode "Interactive"
.NOTES
    Toolkit Exit Code Ranges:
    60000 - 68999: Reserved for built-in exit codes in Deploy-Application.ps1, Deploy-Application.exe, and AppDeployToolkitMain.ps1
    69000 - 69999: Recommended for user customized exit codes in Deploy-Application.ps1
    70000 - 79999: Recommended for user customized exit codes in AppDeployToolkitExtensions.ps1
.LINK
    http://psappdeploytoolkit.com
#>
[CmdletBinding()]
Param (
    [Parameter(Mandatory=$false)]
    [ValidateSet('Install','Uninstall','Repair')]
    [string]$DeploymentType = 'Install',
    [Parameter(Mandatory=$false)]
    [ValidateSet('Interactive','Silent','NonInteractive')]
    [string]$DeployMode = 'Interactive',
    [Parameter(Mandatory=$false)]
    [switch]$AllowRebootPassThru = $false,
    [Parameter(Mandatory=$false)]
    [switch]$TerminalServerMode = $false,
    [Parameter(Mandatory=$false)]
    [switch]$DisableLogging = $false
)

Try {
    ## Set the script execution policy for this process
    Try { Set-ExecutionPolicy -ExecutionPolicy 'ByPass' -Scope 'Process' -Force -ErrorAction 'Stop' } Catch {}

    ##*===============================================
    ##* VARIABLE DECLARATION
    ##*===============================================
    ## Variables: Application
    [string]$appVendor = 'Microsoft Corporation'
    [string]$appName = 'Power BI Desktop'
    [string]$appVersion = ''
    [string]$appArch = ''
    [string]$appLang = ''
    [string]$appRevision = ''
    [string]$appScriptVersion = '1.0.0'
    [string]$appScriptDate = 'XX/XX/20XX'
    [string]$appScriptAuthor = 'Jason Bergner'
    ##*===============================================
    ## Variables: Install Titles (Only set here to override defaults set by the toolkit)
    [string]$installName = ''
    [string]$installTitle = 'Microsoft Power BI Desktop'

    ##* Do not modify section below
    #region DoNotModify

    ## Variables: Exit Code
    [int32]$mainExitCode = 0

    ## Variables: Script
    [string]$deployAppScriptFriendlyName = 'Deploy Application'
    [version]$deployAppScriptVersion = [version]'3.8.4'
    [string]$deployAppScriptDate = '26/01/2021'
    [hashtable]$deployAppScriptParameters = $psBoundParameters

    ## Variables: Environment
    If (Test-Path -LiteralPath 'variable:HostInvocation') { $InvocationInfo = $HostInvocation } Else { $InvocationInfo = $MyInvocation }
    [string]$scriptDirectory = Split-Path -Path $InvocationInfo.MyCommand.Definition -Parent

    ## Dot source the required App Deploy Toolkit Functions
    Try {
        [string]$moduleAppDeployToolkitMain = "$scriptDirectory\AppDeployToolkit\AppDeployToolkitMain.ps1"
        If (-not (Test-Path -LiteralPath $moduleAppDeployToolkitMain -PathType 'Leaf')) { Throw "Module does not exist at the specified location [$moduleAppDeployToolkitMain]." }
        If ($DisableLogging) { . $moduleAppDeployToolkitMain -DisableLogging } Else { . $moduleAppDeployToolkitMain }
    }
    Catch {
        If ($mainExitCode -eq 0){ [int32]$mainExitCode = 60008 }
        Write-Error -Message "Module [$moduleAppDeployToolkitMain] failed to load: `n$($_.Exception.Message)`n `n$($_.InvocationInfo.PositionMessage)" -ErrorAction 'Continue'
        ## Exit the script, returning the exit code to SCCM
        If (Test-Path -LiteralPath 'variable:HostInvocation') { $script:ExitCode = $mainExitCode; Exit } Else { Exit $mainExitCode }
    }

    #endregion
    ##* Do not modify section above
    ##*===============================================
    ##* END VARIABLE DECLARATION
    ##*===============================================

    If ($deploymentType -ine 'Uninstall' -and $deploymentType -ine 'Repair') {
        ##*===============================================
        ##* PRE-INSTALLATION
        ##*===============================================
        [string]$installPhase = 'Pre-Installation'

        ## Show Welcome Message, Close Microsoft Power BI Desktop With a 60 Second Countdown Before Automatically Closing
        Show-InstallationWelcome -CloseApps 'PBIDesktop' -CloseAppsCountdown 60

        ## Show Progress Message (with the default message)
        Show-InstallationProgress

        ## Remove Any Existing Version of Microsoft Power BI Desktop
        $UninstPath = Get-ChildItem -Path "C:\ProgramData\Package Cache\*" -Include PBIDesktopSetup.exe,PBIDesktopSetup_x64.exe -Recurse -ErrorAction SilentlyContinue

        If($UninstPath.Exists)
        {
        Write-Log -Message "Found $($UninstPath.FullName), now attempting to uninstall $installTitle."
        Execute-Process -Path "$UninstPath" -Parameters "/uninstall /quiet /norestart /log C:\Windows\Logs\Software\PowerBIDesktop-Uninstall.log" -WindowStyle Hidden
        }
   
        ##*===============================================
        ##* INSTALLATION
        ##*===============================================
        [string]$installPhase = 'Installation'

        If ($ENV:PROCESSOR_ARCHITECTURE -eq 'x86'){
        Write-Log -Message "Detected 32-bit OS Architecture" -Severity 1 -Source $deployAppScriptFriendlyName

        ## Install Microsoft Power BI Desktop (32-bit Systems)
        Show-InstallationProgress "Installing Microsoft Power BI Desktop (32-bit Systems). This may take some time. Please wait..."
        Execute-Process -Path "$dirFiles\PBIDesktopSetup.exe" -Parameters "/quiet /norestart /log C:\Windows\Logs\Software\PowerBIDesktop-Install.log ACCEPT_EULA=1 DISABLE_UPDATE_NOTIFICATION=1 ENABLECXP=0" -WindowStyle Hidden      
        }
        Else
        {
        Write-Log -Message "Detected 64-bit OS Architecture" -Severity 1 -Source $deployAppScriptFriendlyName

        ## Install Microsoft Power BI Desktop (64-bit Systems)
        Show-InstallationProgress "Installing Microsoft Power BI Desktop (64-bit Systems). This may take some time. Please wait..."
        Execute-Process -Path "$dirFiles\PBIDesktopSetup_x64.exe" -Parameters "/quiet /norestart /log C:\Windows\Logs\Software\PowerBIDesktopx64-Install.log ACCEPT_EULA=1 DISABLE_UPDATE_NOTIFICATION=1 ENABLECXP=0" -WindowStyle Hidden
        }
       
        ##*===============================================
        ##* POST-INSTALLATION
        ##*===============================================
        [string]$installPhase = 'Post-Installation'

    }
    ElseIf ($deploymentType -ieq 'Uninstall')
    {
        ##*===============================================
        ##* PRE-UNINSTALLATION
        ##*===============================================
        [string]$installPhase = 'Pre-Uninstallation'

        ## Show Welcome Message, Close Microsoft Power BI Desktop With a 60 Second Countdown Before Automatically Closing
        Show-InstallationWelcome -CloseApps 'PBIDesktop' -CloseAppsCountdown 60

        ## Show Progress Message (With a Message to Indicate the Application is Being Uninstalled)
        Show-InstallationProgress -StatusMessage "Uninstalling Application $installTitle. Please Wait..."


        ##*===============================================
        ##* UNINSTALLATION
        ##*===============================================
        [string]$installPhase = 'Uninstallation'

        ## Remove Microsoft Power BI Desktop
        $UninstPath = Get-ChildItem -Path "C:\ProgramData\Package Cache\*" -Include PBIDesktopSetup.exe,PBIDesktopSetup_x64.exe -Recurse -ErrorAction SilentlyContinue

        If($UninstPath.Exists)
        {
        Write-Log -Message "Found $($UninstPath.FullName), now attempting to uninstall $installTitle."
        Execute-Process -Path "$UninstPath" -Parameters "/uninstall /quiet /norestart /log C:\Windows\Logs\Software\PowerBIDesktop-Uninstall.log" -WindowStyle Hidden
        }

        ##*===============================================
        ##* POST-UNINSTALLATION
        ##*===============================================
        [string]$installPhase = 'Post-Uninstallation'


    }
    ElseIf ($deploymentType -ieq 'Repair')
    {
        ##*===============================================
        ##* PRE-REPAIR
        ##*===============================================
        [string]$installPhase = 'Pre-Repair'

        ## Show Progress Message (with the default message)
        Show-InstallationProgress


        ##*===============================================
        ##* REPAIR
        ##*===============================================
        [string]$installPhase = 'Repair'


        ##*===============================================
        ##* POST-REPAIR
        ##*===============================================
        [string]$installPhase = 'Post-Repair'


    }
    ##*===============================================
    ##* END SCRIPT BODY
    ##*===============================================

    ## Call the Exit-Script function to perform final cleanup operations
    Exit-Script -ExitCode $mainExitCode
}
Catch {
    [int32]$mainExitCode = 60001
    [string]$mainErrorMessage = "$(Resolve-Error)"
    Write-Log -Message $mainErrorMessage -Severity 3 -Source $deployAppScriptFriendlyName
    Show-DialogBox -Text $mainErrorMessage -Icon 'Stop'
    Exit-Script -ExitCode $mainExitCode
}

For more details, you may refer to this blog:Microsoft Power BI Desktop Install and Uninstall (PowerShell)

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

The code is not working, have you try this yourself.

 

Code is not working with  powershell script.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.