Forum Discussion

micer's avatar
micer
Regular Visitor
10 months ago
Solved

New Usage Metrics Report - page views

Hi all,

 

I am trying to get the report page views out of the new Usage Metrics Report. I connected to the dataset to get more detailed information about the page views, but the numbers i am getting do not seem correct.

 

I need to create a table with the date, report name, page name, viewer name and views count. I noticed that there are 2 tables for views - Report Views and Report Page Views.

The report views table does not contain any information about the page.

The report page views table seems to be missing some information about the report views.

 

I created a measure to count the report views - one report opening means one person opened the report at least once during one day.

I added this measure to the Report Views:

ReportOpening = SUMX(SUMMARIZE('Report views', 'Report views'[Date], 'Report views'[ReportId], 'Report views'[UserId], "Count", 1), [Count])
And this to Report Page Views:
ReportOpening2 = SUMX(SUMMARIZE('Report page views', 'Report page views'[Date], 'Report page views'[ReportId], 'Report page views'[UserKey], "Count", 1), [Count])
 
The result with Report Name only:

So my question is, is it possible that the report page views does not contain all of the information? Is there a way to create a table I described please?

Need Help
  • v-achippa's avatar
    v-achippa
    10 months ago

    Hi micer,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    The difference here is expected.

    • The Report views table logs when a user opens a report like one entry per user per day.
    • The Report page views table logs when pages are loaded inside that report.

    Page level telemetry is collected on the client and sometimes can be missing due to network issues, ad-blockers, switching pages without a server request, embedded/publish scenarios or tenant settings such as per user data or private link. Because of that Report page views can show lower numbers than Report views.

     

    So yes, the Report page views table can miss some information. Please follow below steps:

    • If you want a table with date, report name, page name, viewer and view count, use only the Report page views table and this below measure:
      PageViews = COUNTROWS('Report page views')
    • If you want to count how many users opened the report like regardless of pages viewed, use Report views:
      ReportOpenings = DISTINCTCOUNT('Report views'[UserId])

     

    Thanks and regards,

    Anjan Kumar Chippa

2 Replies

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi micer,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    The difference here is expected.

    • The Report views table logs when a user opens a report like one entry per user per day.
    • The Report page views table logs when pages are loaded inside that report.

    Page level telemetry is collected on the client and sometimes can be missing due to network issues, ad-blockers, switching pages without a server request, embedded/publish scenarios or tenant settings such as per user data or private link. Because of that Report page views can show lower numbers than Report views.

     

    So yes, the Report page views table can miss some information. Please follow below steps:

    • If you want a table with date, report name, page name, viewer and view count, use only the Report page views table and this below measure:
      PageViews = COUNTROWS('Report page views')
    • If you want to count how many users opened the report like regardless of pages viewed, use Report views:
      ReportOpenings = DISTINCTCOUNT('Report views'[UserId])

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi micer,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa