Power BI REST API - Updating Dataset datasource error

[m-cerna]

Hi,

I'm trying to use this REST call in order to update a datalake type connection in a report

- https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup

However I get the following error message when doing so, be it through the documention website itself or PowerShell

{
  "error": {
    "code": "BadRequest",
    "message": "Bad Request",
    "details": [
      {
        "message": "Error converting value \"connectionDetails\" to type 'Microsoft.PowerBI.ServiceContracts.Api.UpdateDatasourceDetails'. Path 'updateDetails[1]', line 14, position 25.",
        "target": "updateDatasourcesRequest.updateDetails[1]"
      },
      {
        "message": "'updateDatasourcesRequest' is a required parameter",
        "target": "updateDatasourcesRequest"
      }
    ]
  }
}

And here is the JSON I'm giving to the call

{
  "updateDetails": [
    {
      "datasourceSelector": {
        "datasourceType": "Extension",
        "connectionDetails": {
          "path": "https://<OLD-DataLake>.azuredatalakestore.net/<PATH-TO-FILE>/",
          "kind": "DataLake"
        }
      },
      "datasourceId": "<Current-GUID>",
      "gatewayId": "<Current-GUID>"
      },
      "connectionDetails": {
        "path": "https://<NEW-DataLake>.azuredatalakestore.net/<PATH-TO-FILE>/",
         "kind": "DataLake"
      }
    }
  ]
}

This is a format found working in this post: https://stackoverflow.com/questions/58518997/how-to-update-a-data-source-via-the-api

If anyone can give me a pointer to what's the issue it would great

Thanks

[v-eachen-msft · Accepted solution]

Hi @m-cerna ,

Based on your json code, I think you missed a "{" or wrote an extra "}". You could check the code again.

[v-eachen-msft]

Hi @m-cerna ,

Has your problem been solved? Was my reply helpful to you? If the problem is resolved, you could accept the reply you like.