This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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-
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??
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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 10 | |
| 8 | |
| 3 | |
| 3 | |
| 2 |