cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TexasBI Frequent Visitor
Frequent Visitor

Can not update datasource through API

Hello,

 

I have followed the documentation for updated a datasource in a spcefic group. https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup#datasource but i still get an error. My body is set up properly and I have checked the spelling of the database and server. All I want to do is change Azure SQL DBs.

 

{
	"updateDetails": [
    {
      "datasourceSelector": {
        "datasourceType": "Sql",
        "connectionDetails": {
          "server": "server1.database.windows.net",
          "database": "database1"
        }
      },
      "connectionDetails": {
        "server": "server2.database.windows.net",
        "database": "database2"
      }
    }
   ]
}

 

 

 

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