Power BI REST API to get datasource information?

[Anonymous]

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.

[Mmahachi]

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??

[Anonymous]

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