Admin - Datasets GetDatasourcesAsAdmin

Service:: Power BI REST APIs

API Version:: v1.0

Returns a list of datasources for the specified dataset.
Note: The user must have administrator rights (such as Office 365 Global Administrator or Power BI Service Administrator) to call this API or authenticate via service principal.
This API processes each request for 0.5 seconds, in the mean time other requests will be queued.

Required scope: Tenant.Read.All or Tenant.ReadWrite.All.
Delegated permissions are supported.
To set the permissions scope, see Register an app.

GET https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/datasources

URI Parameters

Name	In	Required	Type	Description
datasetId	path	True	string

Responses

Name	Type	Description
200 OK	Datasources	OK

Examples

Example

Sample Request

GET https://api.powerbi.com/v1.0/myorg/admin/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/datasources

Sample Response

Status code:: 200

{
  "value": [
    {
      "name": "301",
      "connectionString": "data source=MyServer.database.windows.net;initial catalog=MyDatabase;persist security info=True;encrypt=True;trustservercertificate=False",
      "datasourceType": "Sql",
      "datasourceId": "16a54ccd-620d-4af3-9197-0b8c779a9a6d",
      "gatewayId": "7f1c4e55-544b-403f-b132-da0d3a024674",
      "connectionDetails": {
        "server": "MyServer.database.windows.net",
        "database": "MyDatabase"
      }
    }
  ]
}

Definitions

Datasource	A Power BI datasource
DatasourceConnectionDetails	A Power BI datasource connection details
Datasources	Odata response wrapper for a Power BI datasource collection

Datasource

A Power BI datasource

Name	Type	Description
connectionDetails	DatasourceConnectionDetails	The datasource connection details
connectionString	string	(Deprecated) The datasource connection string. Available only for DirectQuery.
datasourceId	string	The bound datasource ID, which is empty when not bound to a gateway
datasourceType	string	The datasource type
gatewayId	string	The bound gateway ID. Empty when not bound to a gateway. When using a gateway cluster, the gateway ID refers to the primary (first) gateway in the cluster. In such cases, gateway ID is similar to gateway cluster ID.
name	string	(Deprecated) The datasource name. Available only for DirectQuery.

DatasourceConnectionDetails

A Power BI datasource connection details

Name	Type	Description
database	string	The connection database.
server	string	The connection server.
url	string	The connection url

Datasources

Odata response wrapper for a Power BI datasource collection

Name	Type	Description
odata.context	string	OData context
value	Datasource[]	The datasource collection