Deploying large number of client specific dataset

[MoorsTech]

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?

Cheers!

[MoorsTech]

Thanks for the comments, we'll be moving forward with our original approach and deploy our .pbix files via the API.

Cheers

Lukas

[v-jiascu-msft]

Hi @MoorsTech,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft · Accepted solution]

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,
Dale

[Greg_Deckler]

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.