Forum Discussion

Chiwa200's avatar
Chiwa200
New Member
3 months ago
Solved

Get data from Web

Hi, I am trying to get data from Web in Power BI Desktop but it's failing to load after I select the tables. Saying timed out. Anyone with an idea why this is the case?
General Comment
  • stoic-harsh's avatar
    stoic-harsh
    3 months ago

    Hey Chiwa200,

    Thanks for providing additional info. The issue was caused by the Suggested Tables section in the Power BI Web connector. The webpage actually contains only:

    • 1 actual HTML table
    • multiple Power BI inferred Suggested Tables from web-page

    These are not real tables. Power BI creates them while trying to infer tabular structures from the rendered page. This process is computationally heavy and often causes endless loading. The fix is to just select the HTML Table. It should load successfully.

    Best,

    Harshit

stoic-harsh's avatar
stoic-harsh
Super User
3 months ago

Hey Chiwa200,

Thanks for providing additional info. The issue was caused by the Suggested Tables section in the Power BI Web connector. The webpage actually contains only:

  • 1 actual HTML table
  • multiple Power BI inferred Suggested Tables from web-page

These are not real tables. Power BI creates them while trying to infer tabular structures from the rendered page. This process is computationally heavy and often causes endless loading. The fix is to just select the HTML Table. It should load successfully.

Best,

Harshit

Chiwa200's avatar
Chiwa200
New Member
3 months ago

Hi stoic-harsh , thank you for your prompt feedback. It has worked out well.

  • stoic-harsh's avatar
    stoic-harsh
    Super User
    3 months ago

    Happy to help!

    Best,

    Harshit