Power BI REST API UpdateDatasource: Operation is not supported for selector #2 for SQL Server

[MaheshMole]

URL: https://api.powerbi.com/v1.0/myorg/groups/{workspaceId}/datasets/{datasetId}/Default.UpdateDatasourc...

Post Request body: 

{"updateDetails":[
                {
                    "datasourceSelector": {
                        "datasourceType": "Sql",
                        "connectionDetails": {
                            "server": "oldSqlServer.database.windows.net",
                            "database": "oldDatabase"
                        }
                    },
                   
                    "connectionDetails": {
                          "server": "newSqlServer.database.windows.net",
                          "database": "newDatabase"
                    }
                }
            ]}

gives error :

{
    "error": {
        "code": "InvalidRequest",
        "message": "Operation is not supported for selector #2"
    }
}

The same type of request for AnalysisServices datasource works but fails for SQL server. The server and database is correct. We tried updating with same value as well and then also it fails. The same values update works for AnalysisServices datasource. 

We found same type of issue https://community.powerbi.com/t5/Developer/quot-Operation-is-not-supported-for-selector-quot-when-us... in community forum but there is no specific solution. 

[Jayendran · Accepted solution]

Hi @MaheshMole ,

Can you please verify the below restriction 

[MaheshMole]

We are not chaning Datasource type.

We want to change Server Name, Database name, user name and password. Is it mean that changing username and password (connection string paremeter) is not supported?

We are using import data not direct query over Azure SQL so we are not using any joins or merge. 

Regards,

Mahesh