Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

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

Robert Conacher Conacher on 05 Nov 2021 15:12:58

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

the powershell capability is very weak - vote this item up as well
https://ideas.powerbi.com/ideas/idea/?ideaid=6007df26-413e-ec11-a3ee-281878de4cf8

Andy's profile image Profile Picture

Robert Conacher Conacher on 05 Nov 2021 14:27:51

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

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

Dave Putney on 03 Nov 2021 19:42:22

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

This would be great!

Andy's profile image Profile Picture

Chris Schulz on 02 Nov 2021 02:12:25

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

Yes, this. Also need the ability to convert the other way.

Andy's profile image Profile Picture

Robert Conacher Conacher on 01 Nov 2021 17:57:10

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

As a consultancy/vendor this makes it impossible to distribute reports as an automated solution with silent deployment.

Andy's profile image Profile Picture

Gareth Mueller on 14 Oct 2021 13:38:12

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

This completely blocks automated CI/CD as source control should never have .pbix in them.

Andy's profile image Profile Picture

Steven Taub on 06 Oct 2021 15:48:28

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

Do we have any information if this is going to be added functionality and when?

As part of an automated deployment process, this would be a fantastic new feature.

Andy's profile image Profile Picture

Jonathan Bergenblom on 30 Aug 2021 13:09:24

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

Because of GDPR reasons we can't publish the .pbix-files to github. It would be madness for us to have our reports there with sensitive data in them if there ever was a breach. Will you please provide a safe way for us to both version control and deploy a report automatically? There should be a single source of truth for the reports, it shouldn't take long to update to my desktop client and it certainly shouldn't take time for me to publish my changes through a commit/push only. Relying on people using Git LFS or settling with developers publishing by using an unbelievably unrestricted button such as the publish button, is just not the right way to go. 

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.

Merged Idea (7)