Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Any update on that ?
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
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
Okay, then yes I believe that is how you'll have to do it
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
😞
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
3 | |
2 | |
1 | |
1 |
User | Count |
---|---|
7 | |
4 | |
3 | |
3 | |
3 |