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 (78)
- Merged Idea (7)
RE: Powershell automation to create new pbix files from templates (pbit files)
Publishing from a pbix is a long process and not convenient when working with big datasets and multiple developpers (because of the size of the file).
It would be easier to manage (backup history versions, etc.) if an online model could be updated from a pbit instead of a pbix model.
RE: Powershell automation to create new pbix files from templates (pbit files)
Export Power BI report as PBIT using PowerShell or C# to automate the process. Power BI is currently supporting manual process to export PBIT files. However, it is tedious process when you have 100s of reports scattered on multiple workspaces.
RE: Powershell automation to create new pbix files from templates (pbit files)
As a consultancy we have clients who do not have direct access to their Production environments and the software we release needs to be encapsulated within Powershell so it can be distributed through release management software.
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 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.
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.
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?
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.
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.
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!
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