Export PBIT from PBIX and automate the process.

[rvpeddabomma]

Export PBIT from PBIX and automate the process using power Shell or C# .

[smpa01]

@sau001@rvpeddabomma  this is a great question and powershell is to rescue.

Source-> is a folder where you have all the pbix to be batch-converted to pbit

Destination-> is a folder where you will keep all converted pbit file

$items = Get-ChildItem -Path "C:\Users\Source"

$move =For ($i = 0; $i -lt $items.Length; $i++) {
# Write-Host $items[$i] ([System.IO.Path]::GetFileNameWithoutExtension($items[$i]))
Copy-Item -Path "C:\Users\Source\$($items[$i])" -Destination "C:\Users\Destination\$(([System.IO.Path]::GetFileNameWithoutExtension($items[$i]))).pbit"
}

 Please run the above from PowerShell ISE to do the batch conversion from source to destination

[sau001]

From what I understand, you are using PowerShell to change the file extension from PBIX to PBIT.  But,this is not going to remove the data from PBIX. Isn't it?

[smpa01]

let me get back to you later on this

[sau001]

Hello @rvpeddabomma ,

I have a similar problem. Did you manage to find a solution ?

I am surprised that MS has not addressed this issue. 

Thanks,

Sau

[TeigeGao]

Hi @rvpeddabomma ,

Based on my test, PowerBI desktop executive file only provides a parameter to run pbix file, we can only export pbit via PowerBI desktop manually.

Besides, I haven't found a official command line tool to do this.

Best Regards,

Teige