Solved: List all datasets and sources in Power BI service ...

Ysquare · ‎04-02-2023

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?

Migasuke · ‎04-02-2023

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.

Ysquare · ‎04-22-2023

Thanks for the response.

Migasuke · ‎04-02-2023

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.

List all datasets and sources in Power BI service instance