Scraping the Internet

[DrDebit]

I am trying to scrape the internet at www.weather.com with Power Query (Not Power BI) for 10-day weather.

Los Angeles, CA 10-Day Weather Forecast - The Weather Channel | Weather.com

Be prepared with the most accurate 10-day forecast for Los Angeles, CA with highs, lows, chance of precipitation from The Weather Channel and Weather.com

weather.com

When I do, I get a generic box:

This has worked before but isn't working now. I teach a class and love this example. What am I doing wrong?

Thank you!

 

[Norie]

They've changed the site?

 

[DrDebit]

Thank you, Norie. It works in Power Bi...
Is there a way to do the scraping in Power Bi and import it into Excel?

 

[sandy666]

Export data to csv from PBI then import csv to Excel / PQ

 

[DrDebit]

Export data to csv from PBI then import csv to Excel / PQ

Thank you, Sandy...the only problem is that it will not update.
Are the Power Queries that different in Power BI and Excel?

 

[sandy666]

PBI has usually latest version of PQ - older Excels has PQ which is not updated to newest (maybe 365 or 2019 but I'm not sure)
add-in for XL2013 is not updated for sure

 

[sandy666]

for now PBI/PQ is 2.82.5858.1161
check yours

 

[DrDebit]

for now PBI/PQ is 2.82.5858.1161
check yours

Thank you, Sandy. I have the current version of Power BI, but that is not the issue.

The issue is that in Excel (I am using 365). When I use PQ, I am not able to download the data when connecting to the web. I used to be able to do it, but I have tried it on a few computers and the result is the same. Again, many thanks.

 

[sandy666]

so PQ version in 365 is older than PBI
maybe it will help a bit: Integration

btw. update your profile about Excel version, will be helpful for everyone

 

[DrDebit]

so PQ version in 365 is older than PBI
maybe it will help a bit:

btw. update your profile about Excel version, will be helpful for everyone

so PQ version in 365 is older than PBI
maybe it will help a bit: Integration

btw. update your profile about Excel version, will be helpful for everyone

Thank you again, Sandy. I still cannot make it work. Regardless, how do I update my profile?