XML Import - Table Type in Column

Hello, thanks.

I have looked at those, but am unable to get them working with my 'Table' data.  I'm not sure what I'm missing.

To be clear, this is an XML import, and working with a column that has 'Table' cells in it.  When I attempt to use this column, for example as a filter, all that appears is:

O (blank, i.e. nothing)

O [Table]

Inside the [Table] is the actual data, as described in my original post - but all I get is brackets with the word Table in the middle.  As stated originally, I presume I will need a helper column, but cannot find anywhere how to reference or extract data from a Table cell - on either the query side or the report side.  All I can do is look at it on the query side, as clicking on such a cell displays the contained data (successfully) underneath the grid.

Thanks

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