Get data from Web

[Chiwa200]

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?

[stoic-harsh]

Hey @Chiwa200,

Agree with @pcoley. That said, could you provide more context and screenshots? The issue could stem from several different causes, so a bit more detail would help narrow it down.

Best,

Harshit

[pcoley]

Hi @Chiwa200 ,

there are many ways to get data from web. actually you can just have a request that get one specific table or you can do really web scrapping going deeper. 
Many websites split data across multiple pages (and you need to iterate through each page; this requires analyzing the page URL structure to see how it handles pagination). In other scenarios all the tables can be accessed in the same page.
Maybe the query that you have is trying to go through many pages or tables. Maybe you need to have authorizations. Maybe the page is blocking multiple queries... there are many options that generate your issue. If you can please share more info about your script.