Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there
Does anyone manage to scrape data from word documents via PowerBI / Power Query?
Is this doable?
Thank you so much
Solved! Go to Solution.
@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=146
Regards,
Charlie Liao
@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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |