Forum Discussion

lgroger's avatar
lgroger
Advocate I
6 years ago
Solved

custom usage metrics data relationship

I followed these instrucions to create a custom dashboard to view usage metrics on all reports. https://docs.microsoft.com/en-us/power-bi/service-usage-metrics#see-all-workspace-usage-metrics The t...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi lgroger ,

     

    We can connect it in Power BI Desktop and create measure with LiveConnect Mode Based on this document.

     

     

    You can find the hidden UserGUID column in View Table when you create measure in Power BI Desktop.

     

     

    Views has relationship with 'Users' by UserGuid Column and relationship with 'Reports' with ReportGuid Column.

     

    The result of measure ViewsCount is as same as the sum of  'Views'[GranularViewsCount], each row in Views table contain user view how much Granular Views in which page of special report

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi lgroger ,

 

We can connect it in Power BI Desktop and create measure with LiveConnect Mode Based on this document.

 

 

You can find the hidden UserGUID column in View Table when you create measure in Power BI Desktop.

 

 

Views has relationship with 'Users' by UserGuid Column and relationship with 'Reports' with ReportGuid Column.

 

The result of measure ViewsCount is as same as the sum of  'Views'[GranularViewsCount], each row in Views table contain user view how much Granular Views in which page of special report

 


Best regards,