topic Re: how to fetch all Datasources for all Datasets in Developer

how to fetch all Datasources for all Datasets

Anonymous — Mon, 02 Dec 2019 12:41:00 GMT

Hello, i am trying with the PowerShell apis but to no avail. i am looking for a way to retreive all the datasets and their underlying data sources for the whole organization. so i do not want to have to enter the DatasetID ot PowerBIDatasouce api.

anyhelp would be well appreciated

Re: how to fetch all Datasources for all Datasets

Anonymous — Tue, 03 Dec 2019 13:10:21 GMT

Not sure what you mean by "whole organisation" but my guess is all workspaces that your user has access to.

Get all datasets in your organization: https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/get-powerbidataset?view=powerbi-ps#examples (Example 2)

Loop through all datasets and get all datasources in each dataset: https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/get-powerbidatasource?view=powerbi-ps#examples (Example 2 if you only want datasources in your organization in the specified dataset)

You can call the REST api using Powershell , if you want to do that my suggestion would be to get all workspaces which you have access to:

https://docs.microsoft.com/en-us/rest/api/power-bi/groups/getgroups

Loop through all workspaces and for each workspace get all datasets :

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasetsingroup

And then for each dataset get all datasources :

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasourcesingroup

Re: how to fetch all Datasources for all Datasets

Anonymous — Tue, 03 Dec 2019 13:23:59 GMT

Hi thanks for your reply, so when i say 'whole organization' i actually mean the organization.

so it looks like i need to write some powershell script to loop through the results from one api, and add as a parameter to another api.

is that what you mean ?

Re: how to fetch all Datasources for all Datasets

Anonymous — Tue, 03 Dec 2019 13:25:26 GMT

Okay, then yes I believe that is how you'll have to do it

Re: how to fetch all Datasources for all Datasets

Anonymous — Tue, 03 Dec 2019 13:27:54 GMT

mmmmm, fair enough.

i was hoping to run the individual apis, each into a file, and perform some joining in Power BI.

but due to having to have a DatasetID as an input parameter, i cannot run it wide open.

it's a shame as other apis, can be run wide open, with just the 'organization' -scope value

😞

Re: how to fetch all Datasources for all Datasets

Anonymous — Tue, 03 Dec 2019 13:30:26 GMT

This is just a guess from my side, I don't know the Power BI Powershell API, powershell in general, well enough to tell you this is the way to go

Re: how to fetch all Datasources for all Datasets

Anonymous — Tue, 06 Jul 2021 15:16:52 GMT

Any update on that ?