POST /v1.0/myorg/datasets/{datasetId}/Default.UpdateDatasources
Update Datasources
Updates the datasources of the specified dataset from "My Workspace".
Important:
- The original datasource and the new datasource must have the exact same schema.
- For cached models, the dataset must be refreshed to get the data from the new data sources. Wait 30 minutes for the update datasources operation to complete before refreshing.
Required scope: Dataset.ReadWrite.All
To set the permissions scope, see Register an app.
Restrictions
- Update datasources supports the following datasource types:
- SQL Server
- Azure SQL Server
- Analysis Services
- Azure Analysis Services
- OData Feed
- SharePoint
- Oracle
- Teradata
- SapHana
- Changing datasource type is not supported.
- Datasources that contain parameters on the connection string are not supported.
- Datasources which are part of Merged or Joined tables are not supported.
Servers
- https://api.powerbi.com
Path parameters
| Name | Type | Required | Description |
|---|---|---|---|
datasetId |
String | Yes |
Request headers
| Name | Type | Required | Description |
|---|---|---|---|
Content-Type |
String | Yes |
The media type of the request body.
Default value: "application/json" |
Request body fields
| Name | Type | Required | Description |
|---|---|---|---|
updateDetails |
String | No |
How to start integrating
- Add HTTP Task to your workflow definition.
- Search for the API you want to integrate with and click on the name.
- This loads the API reference documentation and prepares the Http request settings.
- Click Test request to test run your request to the API and see the API's response.