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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

report usage metrics - how to view session length

I need to determine how long users are viewing a report in each session to filter out "noise" sessions.  For example, a user could have viewed a report 5 times in one day.  However, if the length of time in each view is <1 minute, then the user probably didn't really inspect the visuals in the report on that day -- he / she probably just opened and closed the report 5 times.  How can I expose this session time in a modified view of the Usage Metrics report?  I have connected to its dataset in Power BI Desktop, but I don't see any field or measure that would allow me to surface this.  I also inspected the audit logs, but I don't see any activity type that would surface this either.

 

For comparison, this metric is available OOTB in the QMC in Qlik Sense.  So, it's reasonable to expect it to be available OOTB in Power BI as well.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@lbendlin 

 

You're right.  Just as a user can introduce noisy sessions by viewing a report several times a day but spending very little time in each session, a user can also introduce noisy sessions by opening a report and stepping away from the workstation.  I solve that by defining an expected session time per report to filter out both scenarios.

View solution in original post

5 REPLIES 5
collinq
Super User
Super User

Hi qubit813,

 

I do not believe that this metric exists at this time.   I didn't find an idea out their that would match this exact need either.  If you create an idea, please respond that you did so and I will vote for it with you!

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

I just posted an idea for this.  The idea name is "Usage Metrics Report - new measure - session time".

Hi @Anonymous,

 

That is great!  Be sure to share the idea with friends, family and co-workers to get mroe votes!




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




how do you plan to measure sessions where the user just leaves the page open and steps away from the computer?

Anonymous
Not applicable

@lbendlin 

 

You're right.  Just as a user can introduce noisy sessions by viewing a report several times a day but spending very little time in each session, a user can also introduce noisy sessions by opening a report and stepping away from the workstation.  I solve that by defining an expected session time per report to filter out both scenarios.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.