Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SaravananM
Frequent Visitor

Downloading PowerBI Workspace with dataset and its owner

HI Team,

 

I have access to PowerBI Admin tenant settings..And I need to download the report which contains all the workspace with the dataset & dataset owners info.. Also I need to download the dataset refresh intervals & schedules..

 

Could you help me on this..

 

Thanks,

Saravanan

4 REPLIES 4
SaravananM
Frequent Visitor

Need to know the list of Workspace and their Dataset which we are using in our Premium Capacity.

Ok. You can use the Power Bi Rest API to request a get groups as admin. That will return all the workspaces with capacity data inside of the response. You need to be a Power Bi Admin or have set the Service Principal in a security group able to explore the admin Rest API.

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-groups-as-admin

NOTE: there is no download from the web site. This is requesting an API. You can use code.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

SaravananM
Frequent Visitor

I need to download the all the workpace with the Dataset information used in our Premium capacity.

ibarrau
Super User
Super User

Hi. I'm not sure what you mean with "the report which contains all the workspaces".  You can download the report pbix one by one unless it is connected to another dataset. You can also download a pbix file from a dataset. Again one by one. (You need to have Enabled the option "Download Reports" in Tenant Settings/Admin portal)

Then if you want data about the schedules you can get it from the PowerBi Rest API because the schedule refresh data in the Service can't be downloaded from the UI.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-schedule-in-group

That request should help.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.