Forum Discussion

jbenson's avatar
jbenson
Icon for Helper III rankHelper III
5 years ago

Web Link

I am trying to bring data over into power bi desktop from this link https://www.innovativeag.com/biddetail.cfm?location=&format=table&groupby=ccommodity&setLocation=&commodity=5354  when i do it says...
Need Help
Show and Tell
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Power Query can only extract data from a web page if it is in a suitable tabular format such as HTML, PHP etc. It won't work on JavaScript rendered tables and many other types.

Try to use Python to do a web crawler.