Web Api Update data source error - "'updateDatasourcesRequest' is a required parameter",

[Anonymous]

Hi 

I am trying to update datasource using webapi getting below error. 

https://api.powerbi.com/v1.0/myorg/datasets/dec84d83-1414-42bf-948f-xxxxxxxxxx/Default.UpdateDatasou...

{
"updateDetails": [
{
"datasourceSelector": {
"datasourceType": "Sql",
"connectionDetails": {
"server": "old",
"database": "old"
}
},
"connectionDetails": {
"server": "new",
"database": "new"
}
}
}
]
}

is it somethng wrong with my JSON?

[v-lid-msft]

Hi @Anonymous ,

Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

Best regards,

[v-lid-msft]

Hi @Anonymous ,

Could you please check if the query of dataset has reached the following limitation mentioned in this document?

• Datasources that contain parameters on the connection string are not supported.
• Datasources which are part of Merged or Joined tables are not supported.

Also there is an additional "}" in the end of your json file.

{
  "updateDetails": [
    {
      "datasourceSelector": {
        "datasourceType": "Sql",
        "connectionDetails": {
          "server": "My-Sql-Server",
          "database": "My-Sql-Database"
        }
      },
      "connectionDetails": {
        "server": "New-Sql-Server",
        "database": "New-Sql-Database"
      }
    }
  ]
}

Best regards,