Power BI
Needs VotesPowershell automation to create new pbix files from templates (pbit files)
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)
- Merged Idea (7)
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.
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.
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
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.
RE: Powershell automation to create new pbix files from templates (pbit files)
Badly needed!
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 !!
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.
RE: Powershell automation to create new pbix files from templates (pbit files)
Yes, this will be very useful feature.
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.
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.