Power BI

Needs Votes

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

Vote (603)

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 (77)

Michel Dekker on 04 Jul 2024 10:31:07

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

For enterprise deployment it is fundamental to support themes and templates in the Service. It is the only way to standardise report creation within large organisations.

Jean Millette on 11 Jun 2024 03:32:24

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

We've implemented most of what we need for source management of Power BI Report files in Perforce. The missing piece? Automated creation of publishable ".pbix" files from ".pbit" template files. Let's get Power BI Desktop->File->Save As out of the process to make things totally automated.Thank you

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!

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)

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.

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.

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.

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

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

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.

Merged Idea (7)