Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm looking at https://www.bet365.com/#/AC/B1/C1/D8/E120986748/F3/I8/ and would like to pull in the main content into PowerBI.
When I open the page in Microsoft Edge and inspect elements that contain data, these are clear to see as per the screenshot (on the right side, there are several DIV elements which contain the data I wish to pull in).
However, when I use Web.BrowserContents to pull in the data, via the below function...
= Web.BrowserContents("https://www.bet365.com/#/AC/B1/C1/D8/E120986748/F3/I8/", [WaitFor=[Timeout=#duration(0, 0, 0, 2)]])
... I instead get a large amount of text that appears to instead be a Javascript function that will (I think) produce the DIV elements I am after. But the text doesn't contain the DIV elements themselves. I have stored this text in the linked .txt file below.
https://drive.google.com/file/d/1KyHrX0mJ76XyS-feTE2u-rBxqcssCiLv/view?usp=sharing
If you can tell what I am getting at, I would really appreciate some help to extract the main contents. Do I have to wait longer to load the page in full perhaps? I am struggling - and I hope I've explained my issue clearly enough!
Thanks
Thanks for reaching out to us.
Although I haven't found a tutorial on crawling data on bet365 directly from PowerBI, you can follow this tutorial to save the data into excel, and then use PowerBI Desktop to get it.
Bet365 - Scraping Live Data with Excel and VBA - YouTube
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |