I had a code that would work for this URL previously, but several months later it now times out instead of returning the data from that page. Does anyone know whether the site has something deliberately blocking web scraping somehow? It is all I can think of as to why it would stop the initial load process, when it previously worked.
Also this appears to connect within Excel Power Query, but not Power BI Desktop - and I need it connecting in the latter given Power BI Desktop's extra functionality for manipulating the data afterwards.
Thank you so much for your reply! That's very useful to know and I appreciate the workaround, given I had given up!!
It looks like the HTML it is now pulling in is a little different to before. I was using CSS selectors to plot an HTML table that pulled in the odds (for example I was looking for .srb_ParticipantLabelWithTeam_Name, .srb_ParticipantLabelWithTeam_Team and .gl-MarketGroupButton_Text, all with a row selector set as .srb-ParticipantLabelWithTeam). You can see these CSS selectors if you inspect element on the odds in the website directly.
Thank you so much! The link may now have expired but this URL is a new match:
I think this may not be your problem. Some websites will set up some measures to prevent webpages from crawling. I also tried the above URL, which also prompts a timeout error, but when I try other websites, it works normally. This may require some crawler knowledge for the website to recognize Power BI as a browser and return data.