Forum Discussion

hokiefan1113's avatar
hokiefan1113
Advocate I
8 years ago
Solved

XML document data in a column

 I'm working with a transaction log on PBI that only shows the failures, and one column, "FAILEDXML" shows the details of each fail in an XML document format (see below). My goal is to take this data...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi hokiefan1113,

     

    You could click the icon highlight in red and expand the table.

     

     

    Best Regards,

    Cherry

hokiefan1113's avatar
hokiefan1113
Advocate I
8 years ago

Hi v-piga-msft thanks for your response. I parsed the data and now it looks like this. Any idea of how to extract the data in the "table" link?

 

RakeshNag's avatar
RakeshNag
New Member
5 years ago

Please use below M Code. This has worked for me. Just change the path and rest it will handle;

let
Path = "C:\test\Outstanding Report BI\AutoRefresh\Current\",
Source = Folder.Files(Path),
XMLImport= Xml.Tables(Source{[#"Folder Path"= Path,Name="TALLY.xml"]}[Content],null,1252),
#"Added Custom" = Table.AddColumn(XMLImport, "Custom", each Table.ToList([Table])),
Transform = #table(#"Added Custom"[Name],List.Zip(#"Added Custom"[Custom]))
in
Transform