Reports - Get Datasources In Group

Returns a list of data sources for the specified paginated report (RDL) from the specified workspace.

Permissions

This API call can be called by a service principal profile. For more information see: Service principal profiles in Power BI Embedded.

Required Scope

Report.ReadWrite.All or Report.Read.All

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

URI Parameters

Name In Required Type Description
groupId
path True
  • string
uuid

The workspace ID

reportId
path True
  • string
uuid

Responses

Name Type Description
200 OK

OK

Examples

Example

Sample Request

GET https://api.powerbi.com/v1.0/myorg/groups/f089354e-8366-4e18-aea3-4cb4a3a50b48/reports/cfafbeb1-8037-4d0c-896e-a46fb27ff229/datasources

Sample Response

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

Definitions

Datasource

A Power BI data source

DatasourceConnectionDetails

The Power BI data source connection details

Datasources

The OData response wrapper for a Power BI data source collection

Datasource

A Power BI data source

Name Type Description
connectionDetails

The data source connection details

connectionString
  • string

(Deprecated) The data source connection string. Available only for DirectQuery.

datasourceId
  • string

The bound data source ID, which is empty when not bound to a gateway

datasourceType
  • string

The data source type

gatewayId
  • string

The bound gateway ID, which is empty when not bound to a gateway. When using a gateway cluster, the gateway ID refers to the primary (first) gateway in the cluster and is similar to the gateway cluster ID.

name
  • string

(Deprecated) The data source name. Available only for DirectQuery.

DatasourceConnectionDetails

The Power BI data source connection details

Name Type Description
database
  • string

The connection database

server
  • string

The connection server

url
  • string

The connection URL

Datasources

The OData response wrapper for a Power BI data source collection

Name Type Description
odata.context
  • string

OData context

value

The data source collection