cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rvpeddabomma
New Member

Export PBIT from PBIX and automate the process.

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

5 REPLIES 5
smpa01
Resident Rockstar
Resident Rockstar

@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


New Animated Dashboard: Sales Calendar


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
Resident Rockstar
Resident Rockstar

let me get back to you later on this


New Animated Dashboard: Sales Calendar


sau001
Helper IV
Helper IV

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
Solution Sage
Solution Sage

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.
Snipaste_2019-04-11_10-14-50.png

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

Best Regards,

Teige

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors