Skip to main content
Microsoft Idea

Power BI

Needs Votes

Powershell automation to create new pbix files from templates (pbit files)

Vote (586) Share
Andy's profile image

Andy on 03 Dec 2017 13:56:06

Now that we have pbit files to help create new pbix files quickly it would be great to be able to automate this process.

Perhaps we could have some Powershell commands that would allow you to pass the needed parameters and output a new pbix file.

Comments (75)
Andy's profile image Profile Picture

Barry Boer, de on 06 Dec 2023 14:38:50

RE: Powershell automation to create new pbix files from templates (pbit files)

Very much needed for better source control and CI/CD options!

Andy's profile image Profile Picture

Sigurður Jónsson on 03 Oct 2023 12:10:26

RE: Powershell automation to create new pbix files from templates (pbit files)

I need to be able to easily export the PBIT from the published PBIX - in an automated manner (API prefered)

Andy's profile image Profile Picture

Alexander Lelonek on 08 Aug 2023 11:52:47

RE: Powershell automation to create new pbix files from templates (pbit files)

We want .pbit files to be downloaded by our costumers so they don't have to get into some data extraction stuff with Power Query. With the possibility to share templates via PowerBI Reportserver we could provide the necessary information to access data and we would be able to maintain this information in a single point of truth using git.

Andy's profile image Profile Picture

on 23 Mar 2023 21:24:07

RE: Powershell automation to create new pbix files from templates (pbit files)

Ability to export report as template (pbit) file via API.

This would enable automated report archiving and automated integration for source control.

Andy's profile image Profile Picture

on 23 Mar 2023 21:24:07

RE: Powershell automation to create new pbix files from templates (pbit files)

When a user publishes an updated pbix model online, the source file is at risk of being lost. It would be useful to allow downloading a pbit file from a model in power bi online so another user could apply future updates to the model, without needing the source pbix file.

Andy's profile image Profile Picture

on 23 Mar 2023 21:24:07

RE: Powershell automation to create new pbix files from templates (pbit files)

Now it is possible import a report from .pbix file, could be import a report template (.pbit) to Power BI Service via API REST? this is a new feature that would be nice to be consolidated. Thanks

Andy's profile image Profile Picture

on 23 Mar 2023 21:23:49

RE: Powershell automation to create new pbix files from templates (pbit files)

Would be great to be able to publish (and optionally upload via web) template files and fill parameters on the fly. Would be great for automated deployment

Andy's profile image Profile Picture

on 23 Mar 2023 21:23:49

RE: Powershell automation to create new pbix files from templates (pbit files)

Publishing from a pbix is a long process and not convenient when working with big datasets and multiple developpers (because of the size of the file).

It would be easier to manage (backup history versions, etc.) if an online model could be updated from a pbit instead of a pbix model.

Andy's profile image Profile Picture

on 23 Mar 2023 21:23:49

RE: Powershell automation to create new pbix files from templates (pbit files)

Export Power BI report as PBIT using PowerShell or C# to automate the process. Power BI is currently supporting manual process to export PBIT files. However, it is tedious process when you have 100s of reports scattered on multiple workspaces.

Andy's profile image Profile Picture

on 23 Mar 2023 21:23:49

RE: Powershell automation to create new pbix files from templates (pbit files)

As a consultancy we have clients who do not have direct access to their Production environments and the software we release needs to be encapsulated within Powershell so it can be distributed through release management software.

Request
1) Powershell Cmdlet to extract a Power PBIT file from a report hosted on Power BI Report Server, for the purpose of using devops pipeline.
2) Powershell Cmdlet to publish a Power PBIT file to a Power BI Report Server enabling parameters and credentials to be set using Powershell

Merged Idea (7)