Forum Discussion

PWheeler's avatar
PWheeler
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's avatar
    orchee
    Mar 02, 2020

    PWheeler So there is List License details for users -> click 

     

    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 🙂

VitalieCiobanu's avatar
VitalieCiobanu
Brass Contributor
Jan 26, 2021

orchee Well, at the moment I don't have the time privilege to learn Graph and the manual export works fine, it's just "manual work".

I'm looking for a way to build a connection, like Power Query does, and then only refresh the data.

  • VitalieCiobanu's avatar
    VitalieCiobanu
    Brass Contributor
    Jan 26, 2021
    I'll look into it. Thank you!

Resources