Bagikan melalui

Datasets - Get Datasources

  • Referensi
Layanan:
Power BI REST APIs
Versi API:
v1.0

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

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
200 
{
  "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

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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

Permintaan sampel

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

Respon sampel

Kode status:
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"
    }
  ]
}

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

Object

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

Object

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

Object

Pembungkus respons OData untuk kumpulan sumber data Power BI

Nama Jenis Deskripsi
@odata.context

string

Konteks OData
value

Datasource[]

Pengumpulan sumber data