Forum Discussion

mmossel's avatar
mmossel
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Usage metrics questions

Hi,

 

I have a few questions about the usage metric report.

 

1. The unique ViewersCount is aggregated, but is it possible to know the origin of the user, for example by region or country?

2. There is not really a connection to the backend, how can we create a data model with an external table that allows us to classify a person to a certain region (e.g. this employee works in country X)?

3. Can we see the time spent per session in one report, or preferablbly time spent in a particular tab within a report?

4. Usage metrics are only visible for 90 days, are we able to retrieve historical data? If that is not possible, what would be the best practice (would that be exporting periodically)?

 

Thank you so much

Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    Hi. About 1 and 2 you can't get that data from those logs. However you can try with more microsfot services like getting data from AD to join it with this one because it shows  the email of the involved users.

    The answer for the 3 i think is no. Check this doc to get an understanding of all the operations you can track:

    https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#operations-available-in-the-audit-and-activity-logs

    You can't get more than 90 days of logs. The best approach for this one is to generate your own historical data. You can create a script to store the last 90 days in a data lake and then it can run all days filling with yesterday data to keep it up to date.

    Hope that helps.

4 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    5 years ago

    Hi. About 1 and 2 you can't get that data from those logs. However you can try with more microsfot services like getting data from AD to join it with this one because it shows  the email of the involved users.

    The answer for the 3 i think is no. Check this doc to get an understanding of all the operations you can track:

    https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#operations-available-in-the-audit-and-activity-logs

    You can't get more than 90 days of logs. The best approach for this one is to generate your own historical data. You can create a script to store the last 90 days in a data lake and then it can run all days filling with yesterday data to keep it up to date.

    Hope that helps.

    • mmossel's avatar
      mmossel
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      Hi ibarrau, with regards to joining with AAD or any external table for that matter, would you have guidance on how to do that? I'm not sure how to proceed.

      • ibarrau's avatar
        ibarrau
        Icon for Super User rankSuper User
        5 years ago

        I don't have a guidance but it should be pretty straight fowards once you have the data from usage and a table with users from AAD. Just relate them by email in Power Bi Desktop.
        The heavier part of this project is taking data from the respective APIs.

        Hope that helps,