List all datasets and sources in Power BI service instance

[Ysquare]

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?

[Ysquare]

Thanks for the response.

[Migasuke · Accepted 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.