Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Hi, Thanks for the solution. Which API method should I use for changing parameters before publishing the report?
@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
Try using an API call - Imports - Post Import - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Hi, Thanks for the solution. Which API method should I use for setting up parameters before publishing?