cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MoorsTech
Advocate I
Advocate I

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?

Cheers!

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft
Microsoft

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

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.

View solution in original post

4 REPLIES 4
MoorsTech
Advocate I
Advocate I

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
Microsoft
Microsoft

Hi @MoorsTech,

 

Could you please mark the proper answers as solutions?

 

 

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.
v-jiascu-msft
Microsoft
Microsoft

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

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.

View solution in original post

Greg_Deckler
Super User IV
Super User IV

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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors