Microsoft 365 Admin Center, User Licence Report

[selenengin]

Hello all,

I want to design a report that displays the licenses assigned to the person on the microsoft 365 admin center.

I am sharing the example.

In this context, I found a report from the power bi apps area. But I can't design it here because there is no relationship between the license and the user table. Could you please help me if you know the true source?

Thanks a lot.

[Anonymous]

Hi @selenengin ,

As far as I know, Microsoft 365 Usage Analytics report will show the data about user activity.

For reference: Microsoft 365 usage analytics

Here I suggest you to export data by "Export Users" botton.

The export file will in csv format. Then create a report by this file.

Text/CSV

Best Regards,
Rico Zhou

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

[selenengin]

Hello,

First of all, thank you for your feedback. But I want to report it on power bi.

Unfortunately, I can't go to the link I gave you below via Apps.

I need to be able to report licenses assigned to a person.