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 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

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.

4 Replies

  • 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

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

    • 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.