Web Scrape The Column of the Table Wasn't Found

[UncleLewis]

Hi all,

Using Power Query in Power BI.
I scraped a table of Federal Holidays for 2021.
I converted it into a function, created a list of years, and tried to invoke the function.
2022 came down without issue.
However, in 2023 I received the error: "The column 'Federal holiday' of the table wasn't found"

I tried again using 2023 as the base year and converted to a function.
This time I added Text.Trim around the headers but I get the same error.

Here is the url for 2021:
https://www.calendarpedia.com/holidays/federal-holidays-2021.html

Thanks,

-w

[ThxAlot]

Nothing special

let
    fx = (yr as number) =>
        let
            Page = Web.Page(Web.Contents("https://www.calendarpedia.com/holidays/federal-holidays-" & Text.From(yr) & ".html")),
            Navi = Page{0}[Data],
            Tb = Table.RemoveLastN(Table.Skip(Navi)),
            #"Promoted Headers" = Table.PromoteHeaders(Tb)
        in
            #"Promoted Headers",
    
    Invocation = List.Transform({2020..2030}, fx),
    #"Combined Tables" = Table.Combine(Invocation)
in
    #"Combined Tables"