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

Richard Park on 18 Jun 2021 17:39:01

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

Upvote this is a barrier to entry to using PowerBI. Lack of automated source control is a HUGE negative.

Andy's profile image Profile Picture

Teus Kappen on 22 May 2021 19:21:45

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

This would so speed up deployment within Healthcare: for each diagnosis the parameters need to be tweaked while the report could stay the same. This would add great value to our patients, nurses, and doctors.

Andy's profile image Profile Picture

Jonathan Burbano on 29 Apr 2021 14:17:06

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

I'm on the same boat!!! I remember this being a request years ago and I am appalled it still has not come to fruition. All of our reports are publish via CICD using Git repos, Azure Repos, the publish and the update of the datasources via their apis. Issue is, I have a team that does an import and the file is 2.2 GB large. Git does not allow anything larger than 100MB and implementing Git LFS in our build and release servers may require some more configuration changes and also devs will need to include changes on their repo to track the pbix files. Not sure if I want to put that owness on them.

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.

Merged Idea (7)