Unable to Display Usage by License Name - Microsoft 365 Usage Analytics

[hussainh]

Hi,

We have the Microsoft 365 Usage Analytics template app in Power BI. How can we view usage data by license/subscription type?

I tried to create a visual with the data fields of "License Name" and "MostRecent-ActiveUsers(%)", but it doesn't work because there is no relationship between the two tables where these fields exist. I tried this in both the browser version and desktop version and haven't had any luck. Please advise on how to create a visual that can show usage by license name.

[iXpert_info]

Hey
I am not sure but check if this can help you

https://radacad.com/build-your-own-power-bi-audit-log-usage-metrics-across-the-entire-tenant

Best
Jay

[hussainh]

Hi Jay,

Thank you for this information however the article you linked is addressing a different issue. The problem I have is with the Microsoft 365 Usage Analytics Dashboard which comes preconfigured from Microsoft as a template app (see image below). As you can see, for example, it provides a total percentage for adoption across the organization. However, I want to be able to break this down by license type such as adoption percentage only for users with E3 license. Does anyone know how this can be done?