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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply

all workspaces and dataset detail

Hi Gurus,

 

I have been tasked by my supervisor to compile a comprehensive report detailing all existing reports across various workspaces. Additionally, I am required to include information regarding their respective datasets, refresh schedules, utilization frequency, and daily refresh counts.

I am seeking guidance on whether this task can be effectively accomplished using Power BI Service.

Your advice and insights are greatly appreciated.

Thank you for your attention and assistance.

2 ACCEPTED SOLUTIONS
Jonvoge
Solution Supplier
Solution Supplier

Hi faheem_Latif_BI

 

The Power BI Service does not provide a very easy way for you to get this information, but with a little bit of API knowledge, you will be able to get all relevant metadata from the PBI Service API: Metadata scanning - Power BI | Microsoft Learn

 

You can also refer to the following community resources:

GitHub - justBlindbaek/PowerBIMonitor: A complete solution to extract the Power BI audit log, Power ...

 

GitHub - RuiRomano/pbimonitor

 



_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

View solution in original post

v-huijiey-msft
Community Support
Community Support

Hi @faheem_Latif_BI ,

 

Jonvoge is partially right, you can view the information via the Power BI REST API.

 

You can view this through the Admin portal in Power BI, however, this approach assumes that you are a global administrator or Power BI administrator.

vhuijieymsft_0-1710731113602.png

 

The Power BI Admin Portal provides an overview of the usage and distribution of reports and datasets across the organization.

vhuijieymsft_1-1710731113604.png

 

You can view your organization's Power BI usage through Usage metrics.

 

It also shows which users and groups in the organization are most active in Power BI.

 

With this information, you can really see how people are using Power BI across the organization.

 

Refresh summary to view scheduled refreshes and see details of refreshes that have occurred.

 

Audit logs can be queried for information about how often reports and dashboards are accessed.

 

For more information about the Admin Portal see:

What is the Microsoft Fabric admin portal? - Microsoft Fabric | Microsoft Learn

 

This post may be helpful to you:

Solved: Extracting Workspace Details - Microsoft Fabric Community

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

2 REPLIES 2
v-huijiey-msft
Community Support
Community Support

Hi @faheem_Latif_BI ,

 

Jonvoge is partially right, you can view the information via the Power BI REST API.

 

You can view this through the Admin portal in Power BI, however, this approach assumes that you are a global administrator or Power BI administrator.

vhuijieymsft_0-1710731113602.png

 

The Power BI Admin Portal provides an overview of the usage and distribution of reports and datasets across the organization.

vhuijieymsft_1-1710731113604.png

 

You can view your organization's Power BI usage through Usage metrics.

 

It also shows which users and groups in the organization are most active in Power BI.

 

With this information, you can really see how people are using Power BI across the organization.

 

Refresh summary to view scheduled refreshes and see details of refreshes that have occurred.

 

Audit logs can be queried for information about how often reports and dashboards are accessed.

 

For more information about the Admin Portal see:

What is the Microsoft Fabric admin portal? - Microsoft Fabric | Microsoft Learn

 

This post may be helpful to you:

Solved: Extracting Workspace Details - Microsoft Fabric Community

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Jonvoge
Solution Supplier
Solution Supplier

Hi faheem_Latif_BI

 

The Power BI Service does not provide a very easy way for you to get this information, but with a little bit of API knowledge, you will be able to get all relevant metadata from the PBI Service API: Metadata scanning - Power BI | Microsoft Learn

 

You can also refer to the following community resources:

GitHub - justBlindbaek/PowerBIMonitor: A complete solution to extract the Power BI audit log, Power ...

 

GitHub - RuiRomano/pbimonitor

 



_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors