Power bi On Prem Data Source Endpoint

[Rohitpowerbinew]

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 : https://somehost/reports/api/v2.0/DataSources/some_ds_id_from_catalog_item_endpoints

Q : How to read and consume the output of the Endpoint  ?

Snap : 

[Rohitpowerbinew]

Hi @Bhavin

I want a sample output with the key names so that I can understand the output generated.I am not able to use Postman / curl for now due to some policy reason on our side.

Would it be possible to share the sample output by hiding / color hovering over the actual values.

[v-achippa]

Hi @Rohitpowerbinew,

Thank you for reaching out to Microsoft Fabric Community.

Since you are currently unable to use tools like Postman/curl, here is a sample response from the GET /DataSources({Id}) API endpoint based on the swagger specification. It shows the field names the API returns.

PBIRS | 2.0 | microsoft-rs | SwaggerHub

{

  "Id": "string",

  "Name": "string",

  "Path": "string",

  "Description": "string",

  "Type": "DataSource",

  "DataSourceType": "string",

  "ConnectionString": "string",

  "Extension": "string",

  "CredentialRetrieval": "string",

  "ImpersonateUser": true,

  "Prompt": "string",

  "Username": "string",

  "Enabled": true

}

This shows the structure of the response not the actual values. You can use this to understand what fields will be present when you are able to run the API.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Rohitpowerbinew,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[BhavinVyas3003 · Accepted solution]

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.