Power Query, getting weather and currency exchange rate data

[lastnn30]

Hi
I want to use Power Query to get data from weather website and also currency exchange rate data. I have googled differnt sites but when I connect to them using Power Query --? Get data --? From Web, I do not see any tables in these sites! Do you recomend any sites to get Weather and Currency rate data using Power Query? Thank you.

[alansidman]

For currency, you might try

https://www.wellsfargo.com/foreign-e...urrency-rates/

as to weather, that is trickier as to location and type of information you are seeking.

[lastnn30]

For currency, you might try

https://www.wellsfargo.com/foreign-e...urrency-rates/

as to weather, that is trickier as to location and type of information you are seeking.

The currency site is really great, thank you very very much. I appreciate the help. About the weather, location is not important, pick any city in the world and for let say the next week or 2. I tried the weather network but it does not show any table. The funny thing, if I used Power Query of Power BI then the weather network will show all the tables but when I used Excel Power Query, I do not see the same tables (same link). So Power BI Power Query is different from Excel Power Query. Thank you once again.

[alansidman]

Here is a site that opens with tables

https://opensnow.com/location/steamboat

Of course, it is for where I live. Not sure if it will work for all locations as it is geared to forecast snowfalls (important in ski country!)

[lastnn30]

Amazing. Thank you so much for all your help. I really appreciate it. Thanks once again. Take care.