Automation of Power BI deployment

[Anonymous]

Hey Community,

I am stuck at a problem where I have to deploy same report for around 900+ clients and which I am doing manually. But it takes around 15 mins for each report as we have to change the DB credetials for each client. So, here I am looking for a automated solution which could help me run a script in powershell and automate the deployment through calling the Power BI Rest APIs or if someone has a better idea. Thanks in advance!!

[satyavelagala]

Hi 

we have a solution where we  automate to create dedicated workspace for each on boarding client and deploy to reports to those workspaces easily 

Regards

Reddy

[v-jayw-msft]

Hi @Anonymous ,

Please take a look at this document and check if it helps.

https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-automation .

Best Regards,

Jay

[lbendlin]

Yes, the Power BI REST API supports that.  What have you tried and where are you stuck?

[Anonymous]

Hi, I am following the steps provided in the below blog, but it doesnot include the step to change the DB credentials for each client as we have different DB for every client.

https://martinschoombee.com/2020/09/15/automating-power-bi-deployments-a-series/