Error with Get Data from web function in Excel

Copper Contributor

Hello Microsoft Community,

I am having an issue with the get data from web function in excel. I am trying to pull data from webpages, it is this one ( if that helps. When I attempt to pull data from this website, it returns the error at the navigator page that "The current preview value is too complex to display." and does not allow me to continue with pulling the data. Is there some way to bypass this or a setting I can change to decrease the chance this appears? I am relatively new to using Excel for processes such as these. 


Thank you and all the best.

1 Reply


Afraid that's nothing to do with this. Practically entire content of the page is generated by javascript. 

Even if Power Query returns something, like for , most probably that will html code, not some structured data.