Microsoft Graph Connect- extract list of all AD users and their license SKUs

AConfusedUser 66 Reputation points
2022-08-03T15:14:54.967+00:00

I need to extract a list of all our Azure AD users and the license SKUs that are assigned to them. I was using Powershell in the past to accomplish this, but I want to report on it in Power BI and my understanding that is Microsoft Graph (Connect since API is not recommended) is the way to do this.

I was not able to find any tutorials or instructions on how to use Graph Connect to extract the data and dump it to some sort of Azure data store that I can then query with PBI.

Can anyone please point me to instructions on how to accomplish this?

Is there a better way to pull out all the AD users and their licenses and dump it to somewhere in Azure? I just don't want to have to run a Powershell script on my local machine (which is what I'm doing now)

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,546 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,927 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Juan Carlos Rendon 1 Reputation point
    2022-08-03T21:26:39.407+00:00

    Hi, you can use Microsoft Graph Data Connect to extract user information from your M365 tenant, you can use the https://github.com/microsoftgraph/dataconnect-solutions/blob/main/datasetschemas/User_v1.md data set and there you can find the user ID and the licenses that are assigned to the user.

    For additional information:

    Microsoft Graph Data Connect (MGDC) provides Access to the M365 data at scale, while allowing administrators granular consent and full control over their Microsoft Graph data. Data Connect streamlines the delivery of this data to Microsoft Azure.

    Here are some links:

    Videos

    Microsoft Graph Data Connect Demo and PBI Dashboards (YouTube video) https://www.youtube.com/watch?v=DiTYBWtzw2o

    Webpage
    Build your first Microsoft Graph Data Connect application https://learn.microsoft.com/en-us/graph/data-connect-quickstart?tabs=Microsoft365

    Microsoft Graph Data Connect – Graph Data Analytics | Microsoft Azure https://azure.microsoft.com/en-us/services/graph-data-connect/

    Overview of Microsoft Graph Data Connect (Microsoft Learn site) https://learn.microsoft.com/en-us/graph/data-connect-concept-overview

    Datasets supported by Microsoft Graph Data Connect ((Microsoft Learn site) https://learn.microsoft.com/en-us/graph/data-connect-datasets