I run a report that gets the 10 day forecast from weather dot com for multiple cities, and my connections for the weather stopped working. I get the following message "[Expression.Error] The column 'Day' of the table wasn't found." Day is the first column of the table that I import from the web. Also, when I just try to redo the Data connection from Web, I get the following message as well Excel error "table highlighting is disabled because this page uses internet explorer's compatibility mode." From my understanding after searching the web, the second error message means that Power Query within Excel can't recognize the tables. Is there any way i can import the 10 day forecast table from weather dot com into Excel? Please help. Thanks.
Bookmarks