Forum Discussion

Rohitpowerbinew's avatar
Rohitpowerbinew
New Member
1 year ago
Solved

Power bi On Prem Data Source Endpoint

Hi Team,   I am trying to understand the output of the Api for On Perm Power Bi ;    Reference : https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/DataSources/GetDataSource Endpoint : http...
Powerbi_Onprem_Datasource_endpoint
  • BhavinVyas3003's avatar
    BhavinVyas3003
    1 year ago

    Hi Rohitpowerbinew ,

     

    To read the output of the endpoint /DataSources({Id}), send a GET request using a tool like Postman or PowerShell:

    GET https://your-server/reports/api/v2.0/DataSources/{DataSourceId}

    Name, Path: Identifies the data source

    ConnectionString: Shows the backend DB connection

    CredentialRetrieval: Tells how credentials are managed (Store, Integrated, etc.)

    Extension: Specifies the data provider (e.g., "SQL")

    Use the ConnectionString and Extension fields to validate what source is being used (SQL, Oracle, etc.), and match credentials via CredentialRetrieval.

BhavinVyas3003's avatar
BhavinVyas3003
Super User
1 year ago

Hi Rohitpowerbinew ,

 

To read the output of the endpoint /DataSources({Id}), send a GET request using a tool like Postman or PowerShell:

GET https://your-server/reports/api/v2.0/DataSources/{DataSourceId}

Name, Path: Identifies the data source

ConnectionString: Shows the backend DB connection

CredentialRetrieval: Tells how credentials are managed (Store, Integrated, etc.)

Extension: Specifies the data provider (e.g., "SQL")

Use the ConnectionString and Extension fields to validate what source is being used (SQL, Oracle, etc.), and match credentials via CredentialRetrieval.