Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
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
You can consider it. Then you need select proper data source connector to get the data from Azure AD.
Best Regards,
Caiyun Zheng