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?

[v-moharafi-msft]

Hi  @Chiwa200  ,

Thank you for reaching out to Microsoft Fabric Community and Thanks to @danextian , @stoic-harsh and @pcoley  for Sharing valuable insights.

Just wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

 Best Regards,

Abdul Rafi.

[danextian]

What URL are you trying to scrape? The website may have a security layer that blocks browser sessions not initiated by a human user, which is how Power Query typically behaves.

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