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

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,

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

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