topic Power bi On Prem Data Source Endpoint in Report Server

Power bi On Prem Data Source Endpoint

Rohitpowerbinew — Mon, 02 Jun 2025 09:26:27 GMT

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 :

Re: Power bi On Prem Data Source Endpoint

BhavinVyas3003 — Mon, 02 Jun 2025 09:54:21 GMT

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.

Re: Power bi On Prem Data Source Endpoint

Rohitpowerbinew — Mon, 02 Jun 2025 09:59:05 GMT

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.

Re: Power bi On Prem Data Source Endpoint

v-achippa — Thu, 05 Jun 2025 09:43:57 GMT

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

Re: Power bi On Prem Data Source Endpoint

v-achippa — Mon, 09 Jun 2025 12:01:32 GMT

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