refresh failed since June's update. with error: We cannot convert the value "[Table]" to type Table.

worry about monthly update: don't know what will be wrong again!

After June's update, a couple of scheduled refreshe failed, with error message: We cannot convert the value "[Table]" to type Table.. The exception was raised by the IDataReader interface

very simple just a merge caused issue. the merge is successful in Power BI desktop, only faied with refresh in service. 

the merge table is from a dataflow.

code:

Source = _filepath_POV_13_2021,
#"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "POV_PBI_Intl.TI")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Data"}),
#"Expanded Data" = Table.ExpandTableColumn(#"Removed Other Columns", "Data", {"EntityCode", "Year", "AccountCode", "CountryCode", "AdjustmentType", "Basket", "Subbasket", "FCAmount", "TaxAmount", "Date"}, {"EntityCode", "Year", "AccountCode", "CountryCode", "AdjustmentType", "Basket", "Subbasket", "FCAmount", "TaxAmount", "Date"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Data",{{"EntityCode", type text}, {"Year", Int64.Type}, {"AccountCode", type text}, {"CountryCode", type text}, {"Basket", type text}, {"Subbasket", type text}, {"FCAmount", Int64.Type}, {"TaxAmount", Int64.Type}, {"AdjustmentType", type text}, {"Date", type date}}),
#"Filtered <>DOMFTI" = Table.SelectRows(#"Changed Type", each ([AccountCode] <> "DOMFTI")),
#"Merged Queries" = Table.NestedJoin(#"Filtered <>DOMFTI", {"EntityCode"}, CHEV21, {"Entity Code"}, "CHEV21", JoinKind.LeftOuter)
in
#"Merged Queries"

CHEV21 is from dataflow, 

let
Source = PowerBI.Dataflows(null),
#"...-0f5e00a035f0" = Source{[workspaceId="...-0f5e00a035f0"]}[Data],
#"...-1a0ef9b18495" = #"...-0f5e00a035f0"{[dataflowId="...-1a0ef9b18495"]}[Data],
CHEV1 = #"...-1a0ef9b18495"{[entity="CHEV21"]}[Data]
in
CHEV1

thanks for help, those are critical business documentation, it worked for long time, now corrupted.

Celine ZHANG