Skip to main content

    Power BI

    Needs Votes

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

    Vote (603) 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 (78)
    Andy's profile image Profile Picture

    Jonathan Brune on 07 Nov 2024 19:27:14

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

    Isn't this just a matter of renaming the file to .PBIX inflight as part of the deployment?

    Andy's profile image Profile Picture

    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.

    Andy's profile image Profile Picture

    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

    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

    Merged Idea (7)