Reports - Get Datasources

Service:: Power BI REST APIs

API Version:: v1.0

Returns a list of datasources for the specified RDL report from "My Workspace".

Required scope: Report.ReadWrite.All or Report.Read.All
To set the permissions scope, see Register an app.

GET https://api.powerbi.com/v1.0/myorg/reports/{reportId}/datasources

URI Parameters

Name	In	Required	Type	Description
reportId	path	True	string uuid	The report id

Responses

Name	Type	Description
200 OK	Datasources	OK

Examples

example

Sample Request

GET https://api.powerbi.com/v1.0/myorg/reports/cfafbeb1-8037-4d0c-896e-a46fb27ff228/datasources

Sample Response

Status code:: 200

{
  "value": [
    {
      "name": "MyDatasource",
      "datasourceType": "AnalysisServices",
      "datasourceId": "f8c56590-43cb-43bf-8daa-233ba2520f51",
      "gatewayId": "1f69e798-5852-4fdd-ab01-33bb14b6e931",
      "connectionDetails": {
        "server": "My-As-Server",
        "database": "My-As-Database"
      }
    }
  ]
}

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. 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.
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