The "Holidays" query has an 'Expression.Error' ... the column 'Weekday' of the table wasn't found.'
I assume this has to do with the webpage missing a header for this column (see attached pics).
Is this something that can be fixed?
Looking back at my lesson 7.02 file I see the column imported with a generic 'Column1' for the header name.
Hi Douglas,
You can edit the hard keyed reference to 'Weekday' with 'Column1' via the formula bar or advanced editor. That should fix the issue.
Let me know if you get stuck.
Mynda
I used the advanced editor to fix the issue. But it turned out to be more than that one column (see attached pic).
Glad you figured it out. What version of Excel do you have? I ask because you're using the files from the 2010 to 2013 version of the course. If you have Excel 2016 or later, then you should be doing the Power Query 2016 onward course.
Mynda
