michal_gasparov's avatar
michal_gasparov
New Member
3 years ago
Status:
Needs Votes

[REST API] Get all DSNs for all Datasets (and Dataflows) in a single paginated call

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


power bi

2 Comments

  • fbcideas_migusr's avatar
    fbcideas_migusr
    New Member
    3 years ago

    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}

Recent ideas