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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AnetaK
Helper V
Helper V

Usage metrics of a dataset (not report)

Hi All,

 

We have several datasets in the PBI Service.

Reports are connected to these datasets (datasets in one workspace, reports in another).

We want to create one report that will show statistics of all these datasets and reports that are connected to them, and information on the viewers.

We can find some basic statistics for a particular dataset.

AnetaK_0-1648044671959.png

 

But we would like to have one report with info on all our datasets in one place.
And maybe it would be possible to have some more information, not only total number of viewers.

Is it possible to create such a report?
If yes, then how?

1 ACCEPTED SOLUTION

Then you are only limited to the out-of-the-box report usage metric. One expansion that you may be able to do:

1- go to any report

2- create the usage metric of the report

3- save the report in the same workspace

4- edit the report to remove the filter that is filtering just 1 report. ( filter pane)

 

This way you can have a report where you can view the report usage for all the reports in the workspace. It may not fulfill what you want to do, but thats the limitation if you dont have rights to access the metadata of the tenant.

View solution in original post

4 REPLIES 4
Tutu_in_YYC
Resident Rockstar
Resident Rockstar

Hi AnetaK,

Currently you can get the most data from the Power BI Scanner API. This is pretty awesome, you will be able to pull meta data of your power bi tenant, including, workspaces, users, dataset and tables and more. 
https://powerbi.microsoft.com/fr-fr/blog/scanner-api-is-now-in-ga/

There are requirements to set this up e.g:
- Must be a power bi admin

- Must set up a security group

- Change settings in Power BI admin portal

 

If you have access to go all above 3, you can set it up by referring to the step-by-step video here:

https://www.youtube.com/watch?v=tvLJsTgt6Y0

Thank you for the answer.

This is an international corporation, we don't have tenant-admin rights, only admin of a workspace.

Then you are only limited to the out-of-the-box report usage metric. One expansion that you may be able to do:

1- go to any report

2- create the usage metric of the report

3- save the report in the same workspace

4- edit the report to remove the filter that is filtering just 1 report. ( filter pane)

 

This way you can have a report where you can view the report usage for all the reports in the workspace. It may not fulfill what you want to do, but thats the limitation if you dont have rights to access the metadata of the tenant.

Thank you. I'll try.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors