Forum Discussion

hokiefan1113's avatar
hokiefan1113
Icon for Advocate I rankAdvocate 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

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

Hi hokiefan1113,

 

You could have a try with clicking Parse to xml.

 

 

 

If you still need help, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best  Regards,

Cherry