topic Re: "Operation is not supported for selector" when using "Update datasources" RE in Developer

"Operation is not supported for selector" when using "Update datasources" REST API

devkeydet — Thu, 08 Mar 2018 14:50:42 GMT

I am trying to automate the publishing of a .pbix file, then change the "url" value of the OData datasource, in order to have a way to automation deployment from dev->test->prod. When I make an http post to:

https://api.powerbi.com/v1.0/myorg/groups/{valid-group-id}/datasets/{valid-dataset-id}/updatedatasources
...with the following body:
{
"updateDetails":[
    {
      "connectionDetails":
      {
        "url": "https://new-value.api.crm.dynamics.com/api/data/v8.2"
      },
      "datasourceSelector":
      {
        "datasourceType": "OData",
        "connectionDetails":
        {
          "url":"https://old-value.api.crm.dynamics.com/api/data/v8.2"
        }
      }
    }
]
}
...the status is 400 with an "Operation is not supported for selector". However, according to my interpretation of https://msdn.microsoft.com/en-us/library/mt814715.aspx this should be supported. Any thoughts on why I am getting this error?

Re: "Operation is not supported for selector" when using "Update datasources" RE

v-ljerr-msft — Thu, 15 Mar 2018 06:13:43 GMT

Hi @devkeydet,

According to the documentation, we will get status 400 when:

Body contains multiple requests with the same datasource selector.
Missing or empty updateDetails in body.
Attempting to update a datasource with invalid connection details.
Datasource type doesn't support update operation.
Attempting to update a connection from cloud to on-premises or on-premises to cloud.

In addition, could you try the solution below to see if it works in your scenario?

1. Use Query Parameter in Data Source dialogs(url) to create a the dataset, so that you can change the data source by just modifying the corresponding Parameter.

2. Use the the Set parameters operation(Power BI REST API) to dynamically change the Parameters in your code, which will also change the actual connection (url).

3. Use the Patch data source operation to update the credentials for the changed data source. Reference: https://community.powerbi.com/t5/Developer/Patching-an-Online-DirectQuery-datasource/m-p/351230

Regards

Re: "Operation is not supported for selector" when using "Update datasources" RE

petermoolenaar — Mon, 10 Sep 2018 14:43:24 GMT

Hi,

After looking around quite intensely, I believe there isn't an actual answer to the problem posed in this thread. At the moment I'm facing the same issue and am getting especially frustrated with the lack of more in depth information from the REST API.

I have a report that works just fine and for which the datasource can be changed when using the Power BI Desktop app. However trying to accomplish the same using the REST API's is failing.

I'm switching between practically identical databases, both cloud and both authenticated using Basic auth.
The body is (a bit redacted):

{
  "updateDetails": [
    {
      "datasourceSelector": {
        "datasourceType": "Sql",
            "connectionDetails": {
                "server": "server-one.database.windows.net",
                "database": "server-one-database-db"
            }
      },
      "connectionDetails": {
        "server": "server-two.database.windows.net",
        "database": "server-two-database-db"
      }
    }
  ]
}

The response I'm receiving is as follows:

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

And... well, that's it actually.

From the datasources fetch from the gateway they are listed as, from which I concluded they are authenticated just fine.

{
            "id": "<uuid>",
            "gatewayId": "<uuid of cloud gw>",
            "datasourceType": "Sql",
            "connectionDetails": "{\"server\":\"server-two.database.windows.net\",\"database\":\"server-two-database-db\"}",
            "credentialType": "Basic",
            "credentialDetails": {
                "useEndUserOAuth2Credentials": false
            }
        },{
            "id": "<uuid>",
            "gatewayId": "<uuid of cloud gw>",
            "datasourceType": "Sql",
            "connectionDetails": "{\"server\":\"server-one.database.windows.net\",\"database\":\"server-one-database-db\"}",
            "credentialType": "Basic",
            "credentialDetails": {
                "useEndUserOAuth2Credentials": false
            }
        }

Why would it be possible to switch datasources using the desktop app, but fail to do so using the REST API?
Is there a way to get a little bit more information from the API?

Regards,

Peter

Re: "Operation is not supported for selector" when using "Update datasources" RE

TexasBI — Wed, 01 May 2019 13:54:41 GMT

I am facing the same exact issue right now. Did you get any traction?? @v-ljerr-msft @petermoolenaar

Re: "Operation is not supported for selector" when using "Update datasources" RE

petermoolenaar — Thu, 02 May 2019 13:50:01 GMT

Hi @TexasBI ,

Eventually, support (after some escallation) was able to provide more details and (if memory serves me right) it turned out to be a column which combined (joined) information from tables. The documentation tells that combining information from different sources might be a problem, but apparantly any join could prove to be giving issues.

Regards,

Peter

Re: "Operation is not supported for selector" when using "Update datasources" RE

Anonymous — Sat, 11 Apr 2020 05:18:49 GMT

I am geeting the same error when I select Update all datasources in workspace.