Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
lizzy
Helper I
Helper I

XML Table Formatting from Word

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.

1 REPLY 1
Tonny021
New Member

I have solved my issue by viewing correct lines and columns you need to install the XML tools plugin,

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.