Datasets - Get Datasources In Group

參考

服務:: Power BI REST APIs

API 版本:: v1.0

從指定的工作區傳回指定數據集的數據源清單。

權限

此 API 呼叫可由服務主體配置檔呼叫。如需詳細資訊，請參閱：Power BI Embedded中的服務主體配置檔。

必要範圍

Dataset.ReadWrite.All 或 Dataset.Read.All

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

URI 參數

名稱	位於	必要	類型	Description
datasetId	path	True	string
groupId	path	True	string (uuid)	工作區標識碼

回應

名稱	類型	Description
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

範例要求

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

範例回覆

狀態碼:: 200

{
  "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

範例要求

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

範例回覆

狀態碼:: 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

範例要求

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

範例回覆

狀態碼:: 200

{
  "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

範例要求

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

範例回覆

狀態碼:: 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

範例要求

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

範例回覆

狀態碼:: 200

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

OData example

範例要求

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

範例回覆

狀態碼:: 200

{
  "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

範例要求

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

範例回覆

狀態碼:: 200

{
  "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

範例要求

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

範例回覆

狀態碼:: 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

範例要求

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

範例回覆

狀態碼:: 200

{
  "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

範例要求

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

範例回覆

狀態碼:: 200

{
  "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

範例要求

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

範例回覆

狀態碼:: 200

{
  "value": [
    {
      "datasourceType": "Sql",
      "connectionDetails": {
        "server": "My-As-Server",
        "database": "My-As-Database"
      },
      "datasourceId": "33cc5222-3fb9-44f7-b19d-ffbff18aaaf5",
      "gatewayId": "0a2dafe6-0e93-4120-8d2c-fae123c111b1"
    }
  ]
}

定義

名稱	Description
Datasource	Power BI 數據源
DatasourceConnectionDetails	Power BI 數據源聯機詳細數據。請參閱取得數據源或在群組中取得數據源中的範例。
Datasources	Power BI 數據源集合的 OData 回應包裝函式

Datasource

Object

Power BI 數據源

名稱	類型	Description
connectionDetails	DatasourceConnectionDetails	數據源聯機詳細數據
connectionString	string	（已淘汰）數據源連接字串。僅適用於 DirectQuery。
datasourceId	string (uuid)	系結的數據源標識碼，當未系結至閘道時，這是空的
datasourceType	string	數據源類型
gatewayId	string (uuid)	系結閘道標識碼，當未系結至閘道時，這是空的。使用閘道叢集時，閘道標識碼是指叢集中的主要（第一個）網關，類似於閘道叢集標識碼。
name	string	（已淘汰）數據源名稱。僅適用於 DirectQuery。

DatasourceConnectionDetails

Object

Power BI 數據源聯機詳細數據。請參閱取得數據源或在群組中取得數據源中的範例。

名稱	類型	Description
account	string	線上帳戶
classInfo	string	連接類別資訊
database	string	連接資料庫
domain	string	線上網域
emailAddress	string	線上電子郵件位址
kind	string	線上種類
loginServer	string	連接登入伺服器
path	string	線上路徑
server	string	連接伺服器
url	string	線上 URL

Datasources

Object

Power BI 數據源集合的 OData 回應包裝函式

名稱	類型	Description
@odata.context	string	OData 內容
value	Datasource[]	數據源集合

AI Skills Fest

共用方式為

Datasets - Get Datasources In Group

權限

必要範圍

URI 參數

回應

範例

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

範例要求

範例回覆

定義

Datasource

DatasourceConnectionDetails

Datasources

其他資源