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 (75)
- Merged Idea (7)
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
RE: Powershell automation to create new pbix files from templates (pbit files)
This would be great!
RE: Powershell automation to create new pbix files from templates (pbit files)
Yes, this. Also need the ability to convert the other way.
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.
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.
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.
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.
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.
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.
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.