Power BI REST API - UpdateDatasource - Operation is not supported for selector

[zbroinx]

Hi,

I'm using PowerBI Rest API to update the datasource. (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup)

Data sources included in this dataset: SqlServer{"server":"bXXXXXX01v\\secondary","database":"XXXXX_DB"}

My JSON:

{
  "updateDetails": [
    {
      "datasourceSelector": {
        "datasourceType": "SQL",
        "connectionDetails": {
          "server": "bXXXXXXX01v\\secondary",
          "database": "XXXXX_DB"
        }
      },
      "connectionDetails": {
        "server": "bXXXXXXX02v",
        "database": "XXXXX_DB"
      }
    }
  ]
}

I'm getting this error:

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

If I change "bXXXXXX01v\\secondary" to "bXXXXXX01v\secondary" I get this:

{
  "error": {
    "code": "BadRequest",
    "message": "Bad Request",
    "details": [
      {
        "message": "Bad JSON escape sequence: \\s. Path 'updateDetails[0].datasourceSelector.connectionDetails.server', line 7, position 35.",
        "target": "updateDatasourcesRequest.updateDetails[0].datasourceSelector.connectionDetails.server"
      },
      {
        "message": "'updateDatasourcesRequest' is a required parameter",
        "target": "updateDatasourcesRequest"
      }
    ]
  }
}

If the original datasource is just "server": "bXXXXXX01v", it works fine.

What might be the problem here?

Can I use special characters in the server option?

[Anonymous]

Hi all,

After several weeks, microsoft support found the problem.

The PBI report was developed in v1.

To solve this:

- install latest version of PBI Desktop

- Open PBI Report

- Save As with another name

- Publish new file

After this, the error is gone.

[v-lionel-msft]

Hi @zbroinx ,

Please show the code corresponding to this error (masking sensitive information).

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This is the code I'm using in the API website:

{
  "updateDetails": [
    {
      "datasourceSelector": {
        "datasourceType": "SQL",
        "connectionDetails": {
          "server": "bXXXXXXX01v\\secondary",
          "database": "XXXXX_DB"
        }
      },
      "connectionDetails": {
        "server": "bXXXXXXX02v",
        "database": "XXXXX_DB"
      }
    }
  ]
}