Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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.UpdateDatasources

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

 

is it somethng wrong with my JSON?

 

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support

    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,

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support

    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,