topic Re: Power BI REST API to get datasource information? in Developer

Power BI REST API to get datasource information?

Anonymous — Tue, 17 Jan 2023 07:34:14 GMT

Hi Develpoers,

I looking for any REST API or any script that can give me Power BI Dataset's datasource related all information like how many tables used, table name, source type: SQL or Web, like whatever information I can fetch.

I tried 1 REST API:

Datasets - Get Datasources

https://api.powerbi.com/v1.0/myorg/admin/datasets/{dataset ID}/datasources

but this is giving me very high level information like-

"value": [

{

"datasourceType": "Web",

"connectionDetails": {

"url": "https://SourcePath.com"

"datasourceId": "xxxxxxxxxxxxxxxxxxxxxxxxx",

"gatewayId": "xxxxxxxxxxxxxxxxxxxxxxxxx"

}

I need more information of the with the dataset ID. Kindly suggest me if there's any way to fetch more information.

Thanks.

Re: Power BI REST API to get datasource information?

Anonymous — Wed, 18 Jan 2023 02:04:55 GMT

Hi @Anonymous,

I'd like to suggest you take a look at power bi metadata scanning API if helps with your scenario:

Metadata scanning - Power BI | Microsoft Learn

Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

Xiaoxin Sheng

Re: Power BI REST API to get datasource information?

Mmahachi — Fri, 20 Jan 2023 16:46:05 GMT

I am also looking for more information about all the field name and definitions, I cannot find this basic information anywhere. For example what is the datasourceinstanceid??