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 |
---|---|---|---|---|
dataset
|
path | True |
string |
ID himpunan data |
Respons
Nama | Jenis | Deskripsi |
---|---|---|
200 OK |
OK |
Contoh
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 |
Datasource |
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 |
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 |
Pengumpulan sumber data |