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 (77)
- Merged Idea (7)
RE: Powershell automation to create new pbix files from templates (pbit files)
Please refer to the list of challenges in this Power BI community post.
Problem 1 - Long waiting time
---------------------------------
I have to manually open the PBIT -->refesh all data (15-20 minutes) --> publish online manually
Problem 2 -Impossible to have a CI/CD
-------------------------------------------
I cannot implement CI/CD solution. I have a PBIT file checked into GIT. I want my CI/CD (Azure Devops) to publish the PBIT to my DEV-Workspace and upon validation, I want my CI/CD to automatically publish to PROD-Workspace.
Problem 3- Solving CI/CD by checking in the PBIX into GIT
----------------------------------------------------------------
We could do convert the PBIT into PBIX (50 MB!) and then store this in GIT. But, this would mean storing customer sensitive data in GIT. We definitely do not want to do.
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
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.