MS365 detailed user license report

[Anonymous]

Is there away of pulling in a user detailed licensing report with the adoption or Usage Analytics

Example

DisplayName	UserPrincipalName	AccountSku	DYN365_CDS_O365_P2	MICROSOFTBOOKINGS	KAIZALA_O365_P3	MICROSOFT_SEARCH	WHITEBOARD_PLAN2
User	User	User@test.com	ENTERPRISEPACK	PendingProvisioning	PendingProvisioning	Disabled	PendingProvisioning

I'm able to gather the data using powershell and then import it into PowerBI. Not sure if there is an easier way to build or at least automate the reporting as I'm still pretty new to this.

What I read is that I will need to use the drilldown features to provide the reporting that I need?

Thanks all.

[dax · Accepted solution]

Hi @Anonymous ,

I find that the detailed User license is not available in Microsoft 365 usage analytics app in powerbi, so I think you need to use powershell to pull data , then create visual. You could refer to https://gallery.technet.microsoft.com/office/Office-365-Reporting-Tool-7987b4c2#content  for details. Or you also could post this problem in O365 forum of rmore suggestions.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.