I have been given a data source that consists of a table inside of a word document. (I don't get to decide the sources, so please don't recommend changing it)
I have gotten really far in being able to parse this table, there's just a few issues still.
Inside of PowerQuery, have unzipped the docx to get the document.xml and located the table inside of it. The table elements all have the address /document/body/tbl/tr/tc/p/r/t. When I expand to this level, though, there are two problems.
First, all of the cells are in a single "t" column, instead of being in the multiple columns.
Secondly, some of the original table cells are showing up as multiple cells, each containing a "table" element. I think this is because of formatting inside of the doument. Is there a way to combine these table elements or expand them even though most of the other entries in the column are text?
Alternatively, is there a way to convert a binary to a better format inside of PowerQuery? I'm currently using this to unzip the file, if there was something similar that could convert it to pdf or html or something else where PBI could easily identify the table, that would also work.
