Forum Discussion

brittany's avatar
brittany
Regular Visitor
9 years ago

XML Import - Table Type in Column

So, I have managed to import an XML via XML.Table, and have learned how to expand the columns in order to gain access to the data and apply it visually - however, there is a data condition that I jus...
Need Help
sherryliu's avatar
sherryliu
Advocate I
9 years ago

Hi Charlie,

I had the same problem Brittany had. Basically, all values for one of my column showed "Table". I looked at these reference you listed but it did not work for me. In the reference doc, when you expand the column with "Table" values in, it seems you can select the data values inside. However, when I tried to expand the column, it said Element:text. I could not find any source that helps to pull table data out. 

 

Here is my export data for this field in xml

 

 Here is what looks like in PowerBi Desktop

 

 

 

 

 

lszymanski's avatar
lszymanski
New Member
8 years ago

Hi Sherry,

 

Did you get an answer or figure this out?  I am trying to import an xml file as well and cannot get to the actual data.

 

Thank you,


LeAnn Szymanski

  • stretcharm's avatar
    stretcharm
    Memorable Member
    8 years ago

    I've not had any issue with XML files.

    Do you have a sample file I that shows the problem?