how to get office365 activationUserDetail by power app in excel

Frédérique BAROUX 1 Reputation point
2021-02-18T15:05:47.31+00:00

Hi, I need to build a costing Dashboard for the It department in Excel. I'm looking for "ActivationUserDetail (with upn, displayname, producttype, lastactivation)" (licence per user) table from office 365 I'd like to get dynamic data from office 365 administration center Today I get this data by exporting reports from "office 365 administration center" as an csv file but it's not dynamic. I've try by powerbi and Microsoft usage analytics, but I Don't find the needed information. I need some help. Thanks

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,800 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Marilee Turscak-MSFT 36,411 Reputation points Microsoft Employee
    2021-02-20T00:21:53.433+00:00

    From what I've seen online, manual export and Microsoft Graph are the two ways of getting that data.

    0 comments No comments