01-10-2019 07:55 AM
we have a bit of an advanced usecase that we're trying to optimize:
We have one Power BI template that is published across 50+ workspaces. Each publication/workspace has its own set of parameters that are currently being manually adjusted. The files then need to have their query steps applied and be published. All of this is a fairly involved and error prone process.
We're therefore looking into automating this entire process using the PowerBI API as there are endpoints for
- Uploading a .pbix file
- Changing parameters
- Refreshing datasets
This is a workable solution for us but I was wondering if there might be a better way? Something like a private / organizational appsource Power BI app or similiar. Does anyone here have some experience with large scale, multi-client Power BI deployments?
01-10-2019 08:23 AM
The options you have available are somewhat dependent on your specific use case. However, it is probably advised to move away from solution templates as I'm not certain that those are really on the roadmap going forward. A lot is changing in that space with the new app workspaces and organization content packs, etc.
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
01-10-2019 11:06 PM
I think you have had the best solution. The App focuses on data organizing rather than deployment management. So if we'd like to do some work programmatically, we need to use the APIs (Application Programming Interface). There is also a PowerShell module. Please refer to powershell/power-bi/overview?view=powerbi-ps.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.