Forum Discussion
Unable to load table via web data connection
Hi all,
I am trying to use the Web connection via Power Query to connect to the below url, but can't seem to do it. There is no tables returned and the HTML code doesn't give anything useful. Can anyone advise please?
https://www.lbma.org.uk/prices-and-data/precious-metal-prices#/table
Many thanks in advance!
Hi Anonymous ,
Scrapping data from a website is not something you can do in every site.
It is recommended that you download the data locally, and then connect to the .xlsx file.
Similar post: Solved: Recover data from a web page with connection - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
Scrapping data from a website is not something you can do in every site.
It is recommended that you download the data locally, and then connect to the .xlsx file.
Similar post: Solved: Recover data from a web page with connection - Microsoft Power BI Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen,
Noted on that. I do agree that due to the difference in how websites are being setup, not every site can be scrapped. I had planned to use that function to automate certain reports for my users, in order to save the manual download process.
I did some further research and found this article below that can bring me further. However, it still get stuck at the very last step, maybe because the website creator inserted some security measures to prevent users from scrapping data off their website.
Web Scraping in Power BI and Excel Power Query - DataChant
So my conclusion is yes, not all websites data can be scrapped. Thanks Stephen for your reply though!
Cheers!