Open "PowerBI" Desktop using PowerShell

[Rohitb]

Hello,

I have a requirement where I have to open PowerBI Desktop Application via PowerShell & also open a PBIX File using PowerShell.

Can someone help me with this ?

[Anonymous · Accepted solution]

Hi @Rohitb ,

At my knowledge, we can get path of the .pbix file and open power bi desktop with the .pbix file using powershell.

Sample:

$PowerBIFilePath = "C:\*** "

Start-Process -FilePath $PowerBIFilePath

Best Regards,

Wearsky

[ahadkarimi]

Open PowerShell:

Place PBIDesktop file path between double quotes, like this:

Start-Process -FilePath "C:\Program Files\Microsoft Power BI Desktop RS\bin\PBIDesktop.exe"

for PBIX files:
Place your file path between double quotes, like this:

Start-Process -FilePath "C:\Users\Ahadk\OneDrive\Desktop\test.pbix"

[NandanHegde]

Hey @ahadkarimi 

Opening the pbix was already stated by @Anonymous . 

The next ask from the user is to save the opened file as another format. 

[ahadkarimi · Accepted solution]

This PowerShell code opens your Power BI and then saves your PBIX file as a PBIT.
You need to change lines two and three in this code according to your path.



Add-Type -AssemblyName System.Windows.Forms

$powerBIPath = "C:\Program Files\Microsoft Power BI Desktop RS\bin\PBIDesktop.exe"

$filePath = "C:\Users\Ahadk\OneDrive\Desktop\Working.pbix"

Start-Process $powerBIPath -ArgumentList $filePath

Start-Sleep -Seconds 30

[System.Windows.Forms.SendKeys]::SendWait('%')

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait('F')

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait('{ENTER}')

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait('{DOWN}')

Start-Sleep -Seconds 0.5

[System.Windows.Forms.SendKeys]::SendWait('{DOWN}')

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait('{ENTER}')

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait('{ENTER}')

Start-Sleep -Seconds 2

[System.Windows.Forms.SendKeys]::SendWait("{TAB}")

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait('{DOWN}')

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait('{DOWN}')

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait("{TAB}")

Start-Sleep -Seconds 1

[System.Windows.Forms.SendKeys]::SendWait("{ENTER}")

[Anonymous · Accepted solution]

Hi @Rohitb ,

At my knowledge, we can get path of the .pbix file and open power bi desktop with the .pbix file using powershell.

Sample:

$PowerBIFilePath = "C:\*** "

Start-Process -FilePath $PowerBIFilePath

Best Regards,

Wearsky

[Rohitb]

Thankyou for your response @Anonymous .

How do I save the PowerBI File as PBIT/PBIP using PowerShell ?

[Anonymous]

Hi @Rohitb ,

I'm afraid that this requirement cannot be easily implemented with PowerShell. This may require programming experience with PowerShell and .NET. As a simple workaround, please try Power Automate Desktop.

Sample:

You can record your operation steps, such as saving, etc…

Best Regards,

Wearsky

[Rohitb]

@Anonymous  Thankyou for your response.

I have already explored Power Automate way but we want to explore via PowerShell/Python/.Net

Can you please help with either of the 3 coding language ?

[NandanHegde]

I am not sure whether this is even possible because based on MSFT documentation; the only was is for it to be done manually