how to fetch all Datasources for all Datasets

[glenmclaren]

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

[Anonymous]

Any update on that ? 

[Anonymous]

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... (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?v... (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

[glenmclaren]

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 ?

ta

[Anonymous]

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

[glenmclaren]

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

😞

[Anonymous]

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