Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Please how do i get list of all dataset and their sources in Power BI service, i.e either exporting it as csv or table or any other means?
Solved! Go to Solution.
Hi @Ysquare ,
You should definitely check REST API, where you can export all datasets (and maybe their sources).
If you want to take advantage of these APIs you should be comfortable with some programing or scripting language. Nevertheless getting basic informations like datasets can be done easily with power shell.
Check following links:
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin
https://www.youtube.com/watch?v=fXbJeIY2CgE&t=247s&ab_channel=GuyinaCube
If you won't find way of exporting sources here in the list, it's possible it is not possible yet.
Thanks for the response.
Hi @Ysquare ,
You should definitely check REST API, where you can export all datasets (and maybe their sources).
If you want to take advantage of these APIs you should be comfortable with some programing or scripting language. Nevertheless getting basic informations like datasets can be done easily with power shell.
Check following links:
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin
https://www.youtube.com/watch?v=fXbJeIY2CgE&t=247s&ab_channel=GuyinaCube
If you won't find way of exporting sources here in the list, it's possible it is not possible yet.