Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola @querycruncher ,
Puede consultar este subproceso para obtener más información:https://community.powerbi.com/t5/Power-Query/Difficulties-with-Expanding-columns-with-list-and-recor...
Saludos
Liang
Si este post ayuda, por favor considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.
Debo mencionar mi código actual que devuelve un error (al intentar expandir registros) es:
let
Source = DocumentDB.Contents("https://acaze2-ai-uat-cdb-ca-fac.documents.azure.com:443/"),
reporting = Source{[id="reporting"]}[Collections],
reporting_live_booking = reporting{[db_id="reporting",id="live_booking"]}[Documents],
#"Expanded Document" = Table.ExpandRecordColumn(reporting_live_booking, "Document", {"data"}, {"Document.data"}),
#"Expanded Document.data" = Table.ExpandRecordColumn(#"Expanded Document", "Document.data", {"ESWEBSERVICE"}, {"Document.data.ESWEBSERVICE"}),
#"Expanded Document.data.ESWEBSERVICE" = Table.ExpandRecordColumn(#"Expanded Document.data", "Document.data.ESWEBSERVICE", {"ECIBOK-OUT"}, {"Document.data.ESWEBSERVICE.ECIBOK-OUT"}),
#"Expanded Document.data.ESWEBSERVICE.ECIBOK-OUT" = Table.ExpandRecordColumn(#"Expanded Document.data.ESWEBSERVICE", "Document.data.ESWEBSERVICE.ECIBOK-OUT", {"BKG-INFO"}, {"Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO"}),
#"Expanded Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO" = Table.ExpandRecordColumn(#"Expanded Document.data.ESWEBSERVICE.ECIBOK-OUT", "Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO", {"SEGS"}, {"Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO.SEGS"}),
#"Expanded Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO.SEGS" = Table.ExpandRecordColumn(#"Expanded Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO", "Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO.SEGS", {"SEG"}, {"Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO.SEGS.SEG"}),
step1 = Table.ExpandRecordColumn(#"Expanded Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO", "Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO.SEGS", {"SEG"}, {"Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO.SEGS.SEG"}),
step2 = Table.RenameColumns(step1,{{"Document.data.ESWEBSERVICE.ECIBOK-OUT.BKG-INFO.SEGS.SEG", "Flights"}}),
Flights1 = step2[Flights],
#"Converted to Table" = Table.FromList(Flights1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
step4 = Table.SelectRows(#"Converted to Table", each [Column1] <> null and [Column1] <> ""),
fieldForRec = Table.AddColumn(step4,"Rec",each if Value.Is([FLTINFO], type record) then [ORIGIN] else null,type record)
in
fieldForRec
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |