Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (630) 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 (73)
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

Andy's profile image Profile Picture

Devon Roderick on 28 Feb 2023 22:11:19

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

This is a very problematic issue. We are working with a multi-national client and this is killing Power BI's reputation at this customer as complications around this have brought the project to a crawl.


Basically it takes forever to deploy an update because the file must be loaded with data first.


Andy's profile image Profile Picture

David Power BI User on 21 Feb 2023 20:46:47

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

Can we get an update on this?


This is needed for obvious CI/CD reasons. There is no point in storing 100's of MB of data in our source control tooling.


Does Microsoft even git? Not sure why we have to explain source control to Microsoft.

Merged Idea (7)