Forum Discussion

Copper Contributor

Mar 02, 2020

Solved

O365 licensing datasource?

I'd like to access my O365 licensing data in a more efficient way. Currently I go to the admin console, go to a licence type, E3 for example, hit export and then import the resulting csv into Excel...

office 365

orchee
Mar 02, 2020
PWheeler So there is List License details for users -> https://docs.microsoft.com/en-us/graph/api/user-list-licensedetails?view=graph-rest-1.0&tabs=http

If you want to go deeper on usage, then you need to go through usage reports, so just keep your expectations low on more details 🙂

orchee

Iron Contributor

Jan 26, 2021

Maybe this can help you:
https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35

VitalieCiobanu

MCT

Jan 26, 2021

I'll look into it. Thank you!