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?

 

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi hokiefan1113,

 

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

 

 

Best Regards,

Cherry