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

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.

Andy's profile image Profile Picture

Misha Romanov on 25 Jan 2023 02:29:14

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

We really need to automate the process of publishing the PBIT file to the service (whether through converting to PBIX or directly). How many votes do we need to promote this idea?

Andy's profile image Profile Picture

Pau Peñaranda on 09 Jan 2023 11:15:59

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

Can't believe this isn't a feature yet in 2023 - would be very helpful for automation of Powershell deployments and easy version control.

Andy's profile image Profile Picture

Aquilles Low on 08 Dec 2022 04:07:35

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

We would really appreciate to have this feature.Please include this on your 2023 product update.

Andy's profile image Profile Picture

F S on 06 Oct 2022 11:43:33

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

We run a script-based version management of our server-based PowerBI reports..Currently, we rely on downloading and holding the full PBIX files (i.e. with all data).This takes up an unnecessary amount of disk space with more than 160 reports.Version management only requires the data model, not the actual data.Therefore, a download option for PBIT files from the server would be very useful here!

Andy's profile image Profile Picture

Craig Jackson on 18 Aug 2022 10:15:42

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

Our DBA only wants us posting PBIT files into devops due to potential GDPR Issues. So the facility to convery PBIT to PBIX and vice versa on the fly would be beneficial

Andy's profile image Profile Picture

Anthony Leshinsky on 19 May 2022 13:41:06

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

Also checking for updates. Anything?? Giant functionality gap preventing us from recommending/using pbi service for many client projects.

Andy's profile image Profile Picture

Miro Maraz on 19 May 2022 13:38:45

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

Badly needed to automate report deployment. Can not believe this is still not possible in 2022.

Andy's profile image Profile Picture

Miro Maraz on 19 May 2022 13:37:03

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

This should have been done long time ago to enable automated deployments. Any updates ?

Merged Idea (7)