Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (582) 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

Ann Weber on 06 Apr 2021 13:19:38

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

Also, now that the interface in the service provides an almost equal environment to desktop for report editing and creation, it would be nice to have templates that people could choose from to create new reports in the service.

Andy's profile image Profile Picture

Holger Kreißl on 25 Mar 2021 09:22:08

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

We have a strong need. It must be possible to set variables for a bpit, to update and save the bpix report for automation purposes

Andy's profile image Profile Picture

Thales Cortez on 24 Mar 2021 14:17:11

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

I'm overloading without any need the amount of "repeated" data, since they're PBIX. If it could be PBIT it would be easier to have multiple reports connecting to a unique PBIX data.

Andy's profile image Profile Picture

P User on 11 Mar 2021 12:24:39

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

Badly needed!

Andy's profile image Profile Picture

Sau D on 08 Mar 2021 13:21:45

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

Just noticed that it has been 5 years since this request was first raised. I am shocked !!

Andy's profile image Profile Picture

Sau D on 08 Mar 2021 13:14:10

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

Please, please - this is a super critical feature. The concept of templates (PBIT) is only meaningful if we can have a deployment system that does not force me to do a local refresh and then publish the PBIX.

We would like to use Azure Devops to automate the publishing of PBIT to the Production environment.
We cannot achieve that without the ability to publish a PBIT.

Andy's profile image Profile Picture

Sagar Salvi on 16 Feb 2021 18:54:50

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

Yes, this will be very useful feature.

Andy's profile image Profile Picture

Aaron Hagopian on 13 Jan 2021 19:13:04

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

I'm hoping to use something like this to regularly backup my reports since many of them are huge, this would allow a much more efficient use of storage.

Andy's profile image Profile Picture

Aliaksandr Stadolnik on 18 Dec 2020 11:45:34

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

There is an API and some 3rd party modules on different platforms to deploy pbix files. This enables a good CI/CD process linked to version control for PBI development. Unfortunately pbix files are really large sometimes + storing data in version controls is not nice, so jsut enabling this functionality on API level will boost CI/CD process.

Andy's profile image Profile Picture

Rajavel Balachandar on 13 Oct 2020 11:38:09

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

This is a much needed functionality. We cannot store PBIX files in source control systems due to compliance and data sensitivity. In-order to automate some of the process, we much be able to convert PBIT to PBIX and vice-versa programmatically. This prevents us from automating our deployment pipelines and enforces a lot of manual effort on developers.

Merged Idea (7)