Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

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.

View solution in original post

4 REPLIES 4
avatar user
Anonymous
Not applicable

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.

v-kkf-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Anonymous ,

 

Could you please use the Html.Table function to get table data? Could you please share your example code?

 

Best Regards,
Winniz

avatar user
Anonymous
Not applicable

Syndicated - Outbound

I have tried this out but am unsure how to apply it.

Consider this table

 

CaptionSourceData
ElementHTMLTable

 

If I do Html.Table([Data]) I get an Expression.Error saying 'Html.Table' wasn't recognized.

Am I going about this correctly?

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Thank you for your reply I will test this out later and (hopefully) come back to mark as a solution

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

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.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)