Unable to update data source for Report having multiple Azure SQL data sources via REST API

[NandanHegde]

Hello Team,

I have a report which has 2 data sources:

1) Azure SQL database 1

2) Azure SQL database 2

Both are in import mode.

This is the code that I am using to update the data source is :

$response=Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/Default.UpdateDatasources" -Method Post -Body $Body | ConvertFrom-Json

I am able to update multiple data sources if the datasource  types are different.

But since in this case the datasource types for both the datasources is same(SQL).
And since the REST API has parameter as the dataset ID which being same for both data sources, the update query is failing.

So is there any way by which we can pass the datasourceid as the parameter to update the datasource or the only way for us the achive the CI CD for suce use cases is to parameteris the data sources.