Usage metrics questions

[mmossel]

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

[ibarrau · Accepted solution]

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-a...

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]

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]

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,

[mmossel]

Hi @ibarrau , thanks for your quick response.

How would you recommend connecting to the data, like via Import or DirectQuery connection to AAD? To make sure the credential data is always up to date and it's not based on an offline table would help to ensure it's not outdated, especially in a large organization.

Can only find how to download the user data: Download a list of users in the Azure Active Directory portal | Microsoft Docs