New in Excel for the web: Power Query Refresh is now generally available for selected data sources

SergeiBaklan​ , thank you so much for your help and guidance. I have checked my regional settings on the web version, and it is/was set to English(US). As well, I have adjusted my last step of the query to Change Type Using Locale and set to English(US). I still end up with blanks being returned to the grid. Any other suggestions? Also, thank you for the guidance on hardcoding column names. I will certainly take that into account on my final query.

Here is my revised query code where you can see the Using Locale.

let
    Source = Excel.CurrentWorkbook(),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] <> "CleanedTable")),
    NICU16 = #"Filtered Rows"{[Name="NICU16"]}[Content],
    #"Removed Top Rows" = Table.Skip(NICU16,1),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
    #"Renamed Columns" = Table.RenameColumns(#"Promoted Headers",{{"NICU", "Metric"}}),
    #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Totals"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Removed Columns", {"Metric"}, "Attribute", "Value"),
    #"Renamed Columns1" = Table.RenameColumns(#"Unpivoted Columns",{{"Attribute", "Date"}}),
    // Pivot the Metric column
    #"Pivoted Column" = Table.Pivot(#"Renamed Columns1", List.Distinct(#"Renamed Columns1"[Metric]), "Metric", "Value"),
    #"Replaced Errors" = Table.ReplaceErrorValues(#"Pivoted Column", {{"PI-productivity index", 0}}),
    #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Replaced Errors", {{"Date", each Text.BeforeDelimiter(_, " "), type text}}),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Extracted Text Before Delimiter", {{"Date", type date}}, "en-US")
in
    #"Changed Type with Locale"