Forum Discussion
Helper IHow to find reports/semantic models bound to a Gateway Connection
Hi ogureisuo , Thank you for reaching out to the Microsoft Community Forum.
No, there’s no single Power BI REST call that returns all dataset datasources tenant-wide without a {datasetId}. The GetDatasources/GetDatasourcesAsAdmin endpoints require a dataset identifier, so the supported pattern is to list datasets (tenant or workspace scope) and then call the per dataset datasources endpoint for each one; only then can you map datasourceId/gatewayId/connectionDetails back to gateway resources. Calling GET /gateways/{gatewayId}/datasources will show gateway side datasource entries, but it won’t tell you which datasets reference them, you still need the dataset side calls to establish the link.
Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Datasets - Get Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Admin - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Helper Iv-hashadapu, Thanks for your help! I have a little problem.. Is there a way to generate all the datasources without entering the datasetid?
https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/datasources
v-hashadapuCommunity Support
Hi ogureisuo , Thank you for reaching out to the Microsoft Community Forum.
No, there’s no single Power BI REST call that returns all dataset datasources tenant-wide without a {datasetId}. The GetDatasources/GetDatasourcesAsAdmin endpoints require a dataset identifier, so the supported pattern is to list datasets (tenant or workspace scope) and then call the per dataset datasources endpoint for each one; only then can you map datasourceId/gatewayId/connectionDetails back to gateway resources. Calling GET /gateways/{gatewayId}/datasources will show gateway side datasource entries, but it won’t tell you which datasets reference them, you still need the dataset side calls to establish the link.
Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Datasets - Get Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Admin - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn