cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarkSL
Helper V
Helper V

Report Usage Metrics - Possible to mix with other data?

Hi,

 

We currently make use of the Power BI Report Usage Metrics datasets to monitor report usage.  We now have a request to do some exception reporting to work out which users have access to reports but who are not using them.  We have a list of users in our own table, however as the usage datasets come from Power BI, they are in affect 'locked down' (as with all Power BI hosted datasets), so we are unable to add columns, view data model or add extra datasets.

 

Can anyone think of a way to fulfil this requirement by mixing usage data with our own?

 

Thanks

 

Mark

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@MarkSL ,

 

If you mean the usage metrics in admin portal, we can't export it as a pbix and modify it. But there's a workaround, you can build your own usage metrics using O365 audit log, please refer to tutoral video below:

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

 

Community Support Team _ Jimmy Tao

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

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@MarkSL ,

 

If you mean the usage metrics in admin portal, we can't export it as a pbix and modify it. But there's a workaround, you can build your own usage metrics using O365 audit log, please refer to tutoral video below:

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

 

Community Support Team _ Jimmy Tao

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

I agree this is a solution but it seems odd that this is still the only solution?

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!