Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
NargisseB
Regular Visitor

Expand Columns / Retrieve columns from Azure using Microsoft Graph API

Hello, I used Microsoft Graph API to extract users information from Azure and I'm trying to get the column AccountEnabled ( I can see the column when I export the users informations into a csv )
I used this code to get the users, but when I try to expand the columns I can't see in the expand list the column I want, I also can't see other information like the usertype ( It's directly shown in Azure ) and many others. When I try to write it manually the columns are empty. I also tried to use $select but it didnt work. 

 

let
    token = GetMSGraphToken(),

    InitialUrl = "https://graph.microsoft.com/v1.0/users",

    Source = Json.Document(Web.Contents(InitialUrl, [Headers=[Authorization="Bearer " & token]])),
    
    #"Transform to table" = Table.FromList(Source[value], Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    
    #"Expand Columns" = Table.ExpandRecordColumn(#"Transform to table" , "Column1", {"id", "displayName", "accountEnabled"}, 
    {"id", "displayName", "accountEnabled"})
in
    #"Expand Colums"

 

The only columns I can see / expand directly are :  Select Columns.PNG

 

Thanks in advance for the help.

 

1 REPLY 1
lbendlin
Super User
Super User

Have you tried using OData.Feed instead of Web.Contents?

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors