Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 hav...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
v-kkf-msft
Community Support
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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?