Publish one report to multiple workspaces by changing parameters

[DataGuruGupta]

I need to automate publishing a common report to 190 clients, each with a unique database connection and workspace. Any guidance or examples from previous implementations would be greatly appreciated.

[3CloudThomas · Accepted solution]

Try using an API call - Imports - Post Import - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[DataGuruGupta]

Hi, Thanks for the solution. Which API method should I use for changing parameters before publishing the report?

[tharunkumarRTK · Accepted solution]

@DataGuruGupta 

I would suggest you to
1. parameterize the database information.
2. Use Powershell commands for publishing the reports to the desired workspace.

3. Change the database connection paramters using TOM

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[3CloudThomas · Accepted solution]

Try using an API call - Imports - Post Import - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[DataGuruGupta]

Hi, Thanks for the solution. Which API method should I use for setting up parameters before publishing?