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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

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 Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.