Power BI
Needs Votes[REST API] Get all DSNs for all Datasets (and Dataflows) in a single paginated call
Michal Gasparovic on 28 Nov 2022 22:14:31
In order to get the list of DATASOURCES (DSNs) for the DATASET, the developer needs to call the following endpoint:
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasources-as-admin
However, that call only works per single dataset. We have around 5000 datasets to collect the information on and to call that endpoint 5000 times is inefficient.
Add the new endpoint into the ADMIN API that works similarly as https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-group-as-admin so it would be:
- single call
- paginated
- expandable for datasources via $expand property
- Comments (1)
RE: [REST API] Get all DSNs for all Datasets (and Dataflows) in a single paginated call
Hi all,It would be great to have an API request that returns a list of all datasources for the organization. Something like this (without Dataset Id required):GET https://api.powerbi.com/v1.0/myorg/admin/datasources?$filter={$filter}&$top={$top}&$skip={$skip}Non-admin version would be:GET https://api.powerbi.com/v1.0/myorg/datasources?$filter={$filter}&$top={$top}&$skip={$skip}