Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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 :
Thanks in advance for the help.
Have you tried using OData.Feed instead of Web.Contents?
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 8 | |
| 8 | |
| 7 |