Forum Discussion
Extract tables from word document
Hi there
Does anyone manage to scrape data from word documents via PowerBI / Power Query?
Is this doable?
Thank you so much
MattAllington has a pattern to extract tables into Power BI from Word saved as HTML - see http://exceleratorbi.com.au/import-tabular-data-pdf-using-power-query/
2 Replies
MattAllington has a pattern to extract tables into Power BI from Word saved as HTML - see http://exceleratorbi.com.au/import-tabular-data-pdf-using-power-query/
Hi Anonymous,
Yes, we can achieve this requirement. You need to leverage the fact that Microsoft Word .docx files are actually ZIP files containing a group of XML files. We will decompress the ZIP file and parse the XML to pull information into Power Query.
Reference
http://www.excelandpowerbi.com/?p=201
http://www.excelandpowerbi.com/?p=146Regards,
Charlie Liao
