Extracting data from a .html file not structured as a table

[Anonymous]

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

[Anonymous · Accepted solution]

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]

Hi @Anonymous ,

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

Best Regards,
Winniz

[Anonymous]

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?

[Anonymous]

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