Datasets - Get Datasources

参考

Service:: Power BI REST APIs

API Version:: v1.0

从 “我的工作区”返回指定数据集的数据源列表。

所需范围

Dataset.ReadWrite.All 或 Dataset.Read.All

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

URI 参数

名称	在	必需	类型	说明
datasetId	path	True	string	数据集 ID

响应

名称	类型	说明
200 OK	Datasources	确定

示例

Analysis Services example

Azure Blobs datasource example

Excel example

Extension datasource example

Microsoft Exchange datasource example

OData example

Oracle example

Salesforce datasource example

SAP HANA example

SharePoint example

SQL example

Analysis Services example

Sample Request

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

Sample Response

Status code:: 200

{
  "@odata.context": "http://api.powerbi.com/v1.0/myorg/groups/222f0f33-3abc-4a57-9f98-ff01bd2aaabb/$metadata#datasources",
  "value": [
    {
      "datasourceType": "AnalysisServices",
      "connectionDetails": {
        "server": "My-As-Server",
        "database": "My-As-Database"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

Azure Blobs datasource example

Sample Request

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

Sample Response

Status code:: 200

{
  "value": [
    {
      "datasourceType": "AzureBlobs",
      "datasourceId": "e0315274-90b6-4fc0-abf2-2d60d448cb04",
      "gatewayId": "7f1c4e55-544b-403f-b132-da0d3a024674",
      "connectionDetails": {
        "account": "myAccount",
        "domain": "blob.core.windows.net"
      }
    }
  ]
}

Excel example

Sample Request

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

Sample Response

Status code:: 200

{
  "@odata.context": "http://api.powerbi.com/v1.0/myorg/groups/222f0f33-3abc-4a57-9f98-ff01bd2aaabb/$metadata#datasources",
  "value": [
    {
      "datasourceType": "File",
      "connectionDetails": {
        "path": "c:\\users\\username\\documents\\orders1.xlsx"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

Extension datasource example

Sample Request

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

Sample Response

Status code:: 200

{
  "value": [
    {
      "datasourceType": "Extension",
      "datasourceId": "70540d95-4c8e-41ae-88c6-27a103b12841",
      "gatewayId": "7f1c4e55-544b-403f-b132-da0d3a024674",
      "connectionDetails": {
        "kind": "AzureDataExplorer",
        "path": "https://myserver.kusto.windows.net"
      }
    }
  ]
}

Microsoft Exchange datasource example

Sample Request

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

Sample Response

Status code:: 200

{
  "value": [
    {
      "datasourceType": "Exchange",
      "datasourceId": "4d126fc8-1568-46aa-ba16-ccf19b18f012",
      "gatewayId": "7f1c4e55-544b-403f-b132-da0d3a024674",
      "connectionDetails": {
        "emailAddress": "john@contoso.com"
      }
    }
  ]
}

OData example

Sample Request

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

Sample Response

Status code:: 200

{
  "@odata.context": "http://api.powerbi.com/v1.0/myorg/groups/222f0f33-3abc-4a57-9f98-ff01bd2aaabb/$metadata#datasources",
  "value": [
    {
      "datasourceType": "OData",
      "connectionDetails": {
        "url": "http://services.odata.org/MyOdata/MyOdata.svc"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

Oracle example

Sample Request

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

Sample Response

Status code:: 200

{
  "@odata.context": "http://api.powerbi.com/v1.0/myorg/groups/222f0f33-3abc-4a57-9f98-ff01bd2aaabb/$metadata#datasources",
  "value": [
    {
      "datasourceType": "Oracle",
      "connectionDetails": {
        "server": "My-Oracle-Server",
        "database": "My-Oracle-Database"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

Salesforce datasource example

Sample Request

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

Sample Response

Status code:: 200

{
  "value": [
    {
      "datasourceType": "Salesforce",
      "datasourceId": "e8a6e0f5-b244-402a-ba5a-4d578609ede3",
      "gatewayId": "7f1c4e55-544b-403f-b132-da0d3a024674",
      "connectionDetails": {
        "classInfo": "report-detail",
        "loginServer": "https://login.salesforce.com/"
      }
    }
  ]
}

SAP HANA example

Sample Request

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

Sample Response

Status code:: 200

{
  "@odata.context": "http://api.powerbi.com/v1.0/myorg/groups/222f0f33-3abc-4a57-9f98-ff01bd2aaabb/$metadata#datasources",
  "value": [
    {
      "datasourceType": "SAPHana",
      "connectionDetails": {
        "server": "My-SapHana-Server",
        "database": "My-SapHana-Database"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

SharePoint example

Sample Request

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

Sample Response

Status code:: 200

{
  "@odata.context": "http://api.powerbi.com/v1.0/myorg/groups/222f0f33-3abc-4a57-9f98-ff01bd2aaabb/$metadata#datasources",
  "value": [
    {
      "datasourceType": "SharePointList",
      "connectionDetails": {
        "url": "https://microsoft.sharepoint.com/hello/myproj/"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

SQL example

Sample Request

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

Sample Response

Status code:: 200

{
  "@odata.context": "http://api.powerbi.com/v1.0/myorg/groups/222f0f33-3abc-4a57-9f98-ff01bd2aaabb/$metadata#datasources",
  "value": [
    {
      "datasourceType": "Sql",
      "connectionDetails": {
        "server": "My-As-Server",
        "database": "My-As-Database"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

定义

名称	说明
Datasource	Power BI 数据源
DatasourceConnectionDetails	Power BI 数据源连接详细信息。请参阅 “获取数据源 ”或 “在组中获取数据源”中的示例。
Datasources	Power BI 数据源集合的 OData 响应包装器

Datasource

Power BI 数据源

名称	类型	说明
connectionDetails	DatasourceConnectionDetails	数据源连接详细信息
connectionString	string	(弃用) 数据源连接字符串。仅适用于 DirectQuery。
datasourceId	string	绑定数据源 ID，在未绑定到网关时为空
datasourceType	string	数据源类型
gatewayId	string	绑定网关 ID，在未绑定到网关时为空。使用网关群集时，网关 ID 是指群集中第一个) 网关的主 (，类似于网关群集 ID。
name	string	(弃用) 数据源名称。仅适用于 DirectQuery。

DatasourceConnectionDetails

Power BI 数据源连接详细信息。请参阅 “获取数据源 ”或 “在组中获取数据源”中的示例。

名称	类型	说明
account	string	连接帐户
classInfo	string	连接类信息
database	string	连接数据库
domain	string	连接域
emailAddress	string	连接电子邮件地址
kind	string	连接类型
loginServer	string	连接登录服务器
path	string	连接路径
server	string	连接服务器
url	string	连接 URL

Datasources

Power BI 数据源集合的 OData 响应包装器

名称	类型	说明
odata.context	string	OData 上下文
value	Datasource[]	数据源集合

通过

Datasets - Get Datasources

所需范围

URI 参数

响应

示例

Analysis Services example

Sample Request

Sample Response

Azure Blobs datasource example

Sample Request

Sample Response

Excel example

Sample Request

Sample Response

Extension datasource example

Sample Request

Sample Response

Microsoft Exchange datasource example

Sample Request

Sample Response

OData example

Sample Request

Sample Response

Oracle example

Sample Request

Sample Response

Salesforce datasource example

Sample Request

Sample Response

SAP HANA example

Sample Request

Sample Response

SharePoint example

Sample Request

Sample Response

SQL example

Sample Request

Sample Response

定义

Datasource

DatasourceConnectionDetails

Datasources

其他资源