Bagikan melalui


Datasets - Get Datasources

Mengembalikan daftar sumber data untuk himpunan data yang ditentukan dari Ruang kerja saya.

Cakupan yang Diperlukan

Dataset.ReadWrite.All atau Dataset.Read.All

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

Parameter URI

Nama Dalam Diperlukan Jenis Deskripsi
datasetId
path True

string

ID himpunan data

Respons

Nama Jenis Deskripsi
200 OK

Datasources

OK

Contoh

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

OData example

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

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

Permintaan sampel

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

Respon sampel

{
  "@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"
    }
  ]
}

Definisi

Nama Deskripsi
Datasource

Sumber data Power BI

DatasourceConnectionDetails

Detail koneksi sumber data Power BI. Lihat contoh di Dapatkan Sumber Data atau Dapatkan Sumber Data Dalam Grup.

Datasources

Pembungkus respons OData untuk kumpulan sumber data Power BI

Datasource

Sumber data Power BI

Nama Jenis Deskripsi
connectionDetails

DatasourceConnectionDetails

Detail koneksi sumber data

connectionString

string

(Tidak digunakan lagi) String koneksi sumber data. Hanya tersedia untuk DirectQuery.

datasourceId

string

ID sumber data terikat, yang kosong saat tidak terikat ke gateway

datasourceType

string

Jenis sumber data

gatewayId

string

ID gateway terikat, yang kosong saat tidak terikat ke gateway. Saat menggunakan kluster gateway, ID gateway mengacu pada gateway utama (pertama) di kluster dan mirip dengan ID kluster gateway.

name

string

(Tidak digunakan lagi) Nama sumber data. Hanya tersedia untuk DirectQuery.

DatasourceConnectionDetails

Detail koneksi sumber data Power BI. Lihat contoh di Dapatkan Sumber Data atau Dapatkan Sumber Data Dalam Grup.

Nama Jenis Deskripsi
account

string

Akun koneksi

classInfo

string

Informasi kelas koneksi

database

string

Database koneksi

domain

string

Domain koneksi

emailAddress

string

Alamat email koneksi

kind

string

Jenis koneksi

loginServer

string

Server masuk koneksi

path

string

Jalur koneksi

server

string

Server koneksi

url

string

URL koneksi

Datasources

Pembungkus respons OData untuk kumpulan sumber data Power BI

Nama Jenis Deskripsi
@odata.context

string

Konteks OData

value

Datasource[]

Pengumpulan sumber data