- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Extracting data from a .html file not structured as a table
Hello community,
I am trying to extract data from a .html file using PQ. The file is not structured as a table which means I have to go looking in different <div> containers. I am experiencing having to drill into 15+ tables before maybe reaching relevant data.
Does anyone have some tips on how to do this? Drilling to 'end' or searching inside the containers? I am kind of out of ideas
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Turns out using PQ for Excel was a bad idea in this case - I have now switched to PQ for PBI and am having no issues unpacking this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Turns out using PQ for Excel was a bad idea in this case - I have now switched to PQ for PBI and am having no issues unpacking this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
Could you please use the Html.Table function to get table data? Could you please share your example code?
Best Regards,
Winniz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have tried this out but am unsure how to apply it.
Consider this table
Caption | Source | Data |
Element | HTML | Table |
If I do Html.Table([Data]) I get an Expression.Error saying 'Html.Table' wasn't recognized.
Am I going about this correctly?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your reply I will test this out later and (hopefully) come back to mark as a solution
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
02-04-2024 05:18 AM | |||
02-14-2024 11:41 AM | |||
04-05-2024 05:59 AM | |||
08-02-2023 04:54 AM | |||
03-18-2024 11:30 PM |
User | Count |
---|---|
18 | |
15 | |
12 | |
8 | |
8 |