The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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,
Happy to help!
I need to download the all the workpace with the Dataset information used in our Premium capacity.
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,
Happy to help!