I need a report of all the Datasets in my organization and its details.

[BarGraph2020]

Hi, I need a report of all the datasets in my organization and its parameters such as id, name, Last refreshed date, owner, users etc.

I am not an admin on the workspaces but have power Bi admin role.

I tried the REST API (GET https://api.powerbi.com/v1.0/myorg/datasets) and was able to get the details of the datasets that I am the owner of but not others. 

1) How do I add myself as an admin to all of the worspaces easily. we have about 10,000 workspaces.

2) For each dataset, how do I get the users, Last sucessful refresh, owner etc. ( like in a for loop ).

I am novice to this admin role and still finding my way around. Any help is greatly appreciated.

My end goal is to create a report dashboard of all the workspaces with its reports and users and their access level, Gateway connections,  Datasets and users in my tenant in a single stop. Any help / ideas from other experienced admins towards reaching my goal are welcome.

Thanks !

[v-kkf-msft]

Hi @BarGraph2020 ,

Has your problem been solved?

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @BarGraph2020 ,

Please try the REST API https://api.powerbi.com/v1.0/myorg/admin/datasets , it returns a list of datasets for the organization.

Referencing: Admin - Datasets GetDatasetsAsAdmin 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens]

Hey @BarGraph2020 ,

it's not That easy to "map" a large Power BI environment, I recommend this article as it describes how to use the newly released Admin APIs https://powerbi.microsoft.com/en-us/blog/announcing-new-admin-apis-and-service-principal-authenticat... 

It's Not Necessaire to be an Admin of a workspace, using these APIs.

Hopefully, this provides an idea on how to tackle your challenge.

Regards,

Tom