Forum Discussion
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?
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
Hi stoic-harsh , thank you for your prompt feedback. It has worked out well.
Happy to help!
Best,
Harshit