Forum Discussion
Helper IIWeb scraping to access tab2
Hi Superusers
I am trying to scrape this site -
for fund prices. In the pic below fund price is on (GREEN box) Tab2 and I'd like to create a table like that in the BLUE box. Sectorid (RED box) is a choice in the URL I like the query to loop the various ids. Firstly, if I could find a way to access TAB2 I could then tackle the next part.
Prices & Yields tab
If I go to HOME tab > New source > Web > enter the URL above. Then if I click on Add table using examples I am unable to access Prices & yields tab so not able to build with an example. Is there another way to access it 🤔
Below is the website source information.
Prices & yields is data-index="2" or id="2".
The table is class = "results__table"
 
I have hit a brick wall with this and hoping someone in the community can find a way through?
Much appreciate any help!
Thanks
1 Reply
V-lianl-msftCommunity Support
Hi KM007 ,
I have looked at the URL you provided and found that ajax was used to refresh and fill the page.
In this respect, power Bi has some limitations.You can consider using Python to get the data from such websites.
You can also try to use power query to refactor browser requests to access data.
Refer:
https://community.powerbi.com/t5/Desktop/Table-not-found-using-Web-option-in-Get-Data/td-p/172372
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.