How to join Usage Metrics data with external tables (e.g. Azure AD) to classify users

[mmossel]

Hi,

I would like to know how to enrich usage statistics with external tables. For example, geographic data from each user / viewer is not available because Power BI doesn't provide access to backend data. However, since email address is visible, I think it should be possible to link this to AAD data and infer the respective viewer's subsidiary from there.

What are the steps to connect usage metrics data with external tables and/or AAD?

[v-cazheng-msft · Accepted solution]

Hi, @mmossel 

You can connect to Model of the Dashboard Usage Metrics by Power BI datasets connector in Desktop, convert the connection mode from Live Connection to Direct Query and then import the file downloaded from Azure AD to create report.

You can refer Create a copy of the usage report, Sign-ins report and Using DirectQuery for live connections.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mmossel]

Thanks for the suggestion! @v-cazheng-msft 

To query AAD, would you recommend using Microsoft Graph API? Here’s the documentation to get user returns: Get a user - Microsoft Graph v1.0 | Microsoft Docs

• Check the thread here too for some extra context: Solved: Re: Get Data - Active Directory - Microsoft Power BI Community

[v-cazheng-msft]

You can consider it. Then you need select proper data source connector to get the data from Azure AD.

Best Regards,

Caiyun Zheng