Datasets - Get Gateway Datasources

Returns a list of gateway data sources for the specified dataset from My workspace.

Important

This API call is deprecated, use Get Datasources instead.

Required Scope

Dataset.ReadWrite.All or Dataset.Read.All

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

URI Parameters

Name In Required Type Description
datasetId
path True
  • string

The dataset ID

Responses

Name Type Description
200 OK

OK

Examples

Example

Sample Request

GET https://api.powerbi.com/v1.0/myorg/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/Default.GetBoundGatewayDatasources

Sample Response

{
  "value": [
    {
      "id": "16a54ccd-620d-4af3-9197-0b8c779a9a6d",
      "gatewayId": "7f1c4e55-544b-403f-b132-da0d3a024674",
      "datasourceType": "Sql",
      "connectionDetails": "{\"server\":\"MyServer.database.windows.net\",\"database\":\"MyDatabase\"}"
    }
  ]
}

Definitions

credentialType

The type of data source credential

GatewayDatasource

A Power BI gateway data source

GatewayDatasourceCredentialDetails

The data source credential details

GatewayDatasources

The OData response wrapper for a Power BI gateway data source collection

credentialType

The type of data source credential

Name Type Description
Anonymous
  • string
Basic
  • string
Key
  • string
OAuth2
  • string
Windows
  • string

GatewayDatasource

A Power BI gateway data source

Name Type Description
connectionDetails
  • string

Connection details in JSON format

credentialDetails

The connection details for the data source that needs update. The connection details are mandatory when the dataset has more than one data source.

credentialType

The type of data source credential

datasourceName
  • string

The name of the data source

datasourceType
  • string

The type of data source.

API name for the data source
ActiveDirectory AdobeAnalytics AdoDotNet
AnalysisServices AzureBlobs AzureDataLakeStorage
AzureMarketplace AzureTables BizTalk
CDPA CustomConnector CustomHttpApi
DB2 Essbase EventHub
Excel Exchange Extension
Facebook File Folder
GoogleAnalytics Hdfs HDInsight
Informix MQ MySql
OData ODBC OleDb
Oracle PostgreSql PowerQueryMashup
PubNub Salesforce SAPBW
SAPBWMessageServer SapErp SAPHana
SharePoint SharePointDocLib SharePointList
Sql Sybase Teradata
UIFlow Web
gatewayId
  • string

The associated gateway ID. When using a gateway cluster, the gateway ID refers to the primary (first) gateway in the cluster and is similar to the gateway cluster ID.

id
  • string

The unique ID for the data source

GatewayDatasourceCredentialDetails

The data source credential details

Name Type Description
useEndUserOAuth2Credentials
  • boolean

Whether the end-user Azure AD identity (OAuth 2.0 credentials) is used when connecting to the data source in DirectQuery mode. Use with data sources that support single sign-on (SSO).

GatewayDatasources

The OData response wrapper for a Power BI gateway data source collection

Name Type Description
odata.context
  • string

OData context

value

The list of gateway data sources