共用方式為

Datasets - Get Datasources

  • 參考
服務:
Power BI REST APIs
API 版本:
v1.0

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

必要範圍

Dataset.ReadWrite.All 或 Dataset.Read.All

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

URI 參數

名稱 位於 必要 類型 Description
datasetId
 path True

string

數據集標識碼

回應

名稱 類型 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/datasets/{datasetId}/datasources

範例回覆

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

範例要求

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/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/datasets/{datasetId}/datasources

範例回覆

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

範例要求

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/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/datasets/{datasetId}/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/datasets/{datasetId}/datasources

範例回覆

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

範例要求

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

範例回覆

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

範例要求

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/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/datasets/{datasetId}/datasources

範例回覆

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

範例要求

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

範例回覆

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

範例要求

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

範例回覆

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

定義

名稱 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[]

數據源集合