Is there a way to batch change the data source connection string and publish to multiple workspaces?

[Anonymous]

Hello,

I have a situation where I need to deploy one version of report to different workspaces and change connection string to customer specific database. I know there is an import API for deploying to workspaces but not sure how to do that. Is there an example or video on how to use import API along with changing connection string?

[v-danhe-msft]

Hi @Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft]

Hi @Anonymous ,

Based on my research, you could refer to below blog about the parameters in query editor to change the data source:

https://biinsight.com/power-bi-desktop-query-parameters-part-1/

Regards,

Daniel He