Forum Discussion
Get Data not showing from Web source
Hi Becca94 ,
Agree with lbendlin,
It appears to be a change in the architecture of this site. The data tables in the page are rendered in JS and embedded in iframe, you can see the html code of the page embedded in the iframe on the page:
But Power Query's Web.BrowserContents (which is the same as web connector you are using in Power BI now) can't get to this data in this type.
So that tutorial you are learning from should be outdated, if you just need to learn how to get data from the web, replace it with a viable site. If you definitely need to get data from that site, maybe you can try to use a python crawler, or try to get its corresponding API that doesn't require a token (but that's difficult).
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHello, Becca94 ,
I tried it myself. I think the issue is that the content you want is dynamically loaded and isn't available upon the first scan. I wonder how you even got the second screen (the expected result).
The 'Expected Result" was taken from the lesson plan. I couldn't get that result myself 😞
Hi Becca94 ,
Agree with lbendlin,
It appears to be a change in the architecture of this site. The data tables in the page are rendered in JS and embedded in iframe, you can see the html code of the page embedded in the iframe on the page:
But Power Query's Web.BrowserContents (which is the same as web connector you are using in Power BI now) can't get to this data in this type.
So that tutorial you are learning from should be outdated, if you just need to learn how to get data from the web, replace it with a viable site. If you definitely need to get data from that site, maybe you can try to use a python crawler, or try to get its corresponding API that doesn't require a token (but that's difficult).
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.