Frequent Visitor
Posts: 15
Registered: ‎12-22-2015

Deploying large number of client specific dataset

Hey everyone,


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

  1. Uploading a .pbix file
  2. Changing parameters
  3. 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?


Super User
Posts: 9,892
Registered: ‎07-11-2015

Re: Deploying large number of client specific dataset

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!

Community Support Team
Posts: 7,295
Registered: ‎05-02-2017

Re: Deploying large number of client specific dataset

Hi @MoorsTech,


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.


Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.