topic Re: Power BI REST API UpdateDatasource: Operation is not supported for selector #2 for SQL Server in Developer

Power BI REST API UpdateDatasource: Operation is not supported for selector #2 for SQL Server

MaheshMole — Sat, 25 Apr 2020 18:01:55 GMT

URL: https://api.powerbi.com/v1.0/myorg/groups/{workspaceId}/datasets/{datasetId}/Default.UpdateDatasources

Post Request body:

{"updateDetails":[ { "datasourceSelector": { "datasourceType": "Sql", "connectionDetails": { "server": "oldSqlServer.database.windows.net", "database": "oldDatabase" } }, "connectionDetails": { "server": "newSqlServer.database.windows.net", "database": "newDatabase" } } ]}

gives error :

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

The same type of request for AnalysisServices datasource works but fails for SQL server. The server and database is correct. We tried updating with same value as well and then also it fails. The same values update works for AnalysisServices datasource.

We found same type of issue https://community.powerbi.com/t5/Developer/quot-Operation-is-not-supported-for-selector-quot-when-using/m-p/372441 in community forum but there is no specific solution.

Re: Power BI REST API UpdateDatasource: Operation is not supported for selector #2 for SQL Server

Jayendran — Mon, 27 Apr 2020 11:07:10 GMT

Hi @MaheshMole ,

Can you please verify the below restriction

Re: Power BI REST API UpdateDatasource: Operation is not supported for selector #2 for SQL Server

MaheshMole — Mon, 27 Apr 2020 17:38:24 GMT

We are not chaning Datasource type.

We want to change Server Name, Database name, user name and password. Is it mean that changing username and password (connection string paremeter) is not supported?

We are using import data not direct query over Azure SQL so we are not using any joins or merge.

Regards,

Mahesh