I waned to practice using PowerQuery by importing data from external websites, however where can I go to do so. I tried the Microsoft Azure but that didn't work like how I hoped. I was hoping to get historical weather data as well as population data by areas.
Thanks!
Hi Joe,
When getting data from the web you are limited to websites that structure their data in a HTML Table. If they use JavaScript to build the table on the fly then Power Query can't get this data.... unless you know how to write JavaScript (I don't 🙁 ).
You can tell if it's in the right format because Power Query will return a list of tables you can grab, if there aren't any tables listed then you're out of luck.
Just to be clear, if you're wanting to get data from Microsoft Azure then you use the 'From Azure' menu as opposed to the 'From Web' option.
Kind regards,
Mynda
