Dear all,
it's the first message i'm writing in the community. If some detail will be missing just sorry me and let me know how i can improve the communication.
I've prepared a Dataset some months ago coming from the merging of three separate SQL table.
The dataset is the same with no change since months, until today when i've got the following error message:
DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
/
let
Source = Table.Combine({DS_ORDER_BACKLOG, DS_PERIOD_REVENUE}),
#"Appended Query" = Table.Combine({Source, DS_BUDGET_REVENUE}),
#"Appended Query1" = Table.Combine({#"Appended Query", DS_HOT_OFFER}),
#"Appended Query2" = Table.Combine({#"Appended Query1", DS_HOT_OPPORTUNITY}),
#"Pivoted Column" = Table.Pivot(#"Appended Query2", List.Distinct(#"Appended Query2"[Type]), "Type", "Value", List.Sum),
#"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"BACKLOG","REVENUE", "BUDGET", "Hot-Offer", "Hot-Opp"}),
#"Renamed Columns" = Table.RenameColumns(#"Replaced Value",{{"CUSTOMER_NAME", "Customer"}, {"COMPANY_CODE", "Platform"}, {"CUSTOMER_COUNTRY_DESC", "Custom. Country"}, {"AREA_DESC", "Area"}, {"MATERIAL_GROUP", "Material Group"}, {"HIERARCHY_III", "Product"}, {"REVENUE", "ACTUAL"}}),
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([Customer] <> "GmbH" and [Customer] <> "bH" and [Customer] <> "O GmbH" and [Customer] <> "THPatz"))
in
#"Filtered Rows"The red line is the one that now is not working anymore.
No changes happened in SQL and no changes have been made on the Dataset for months.
Is there anything i can do to solve this matter or to check what to do?
Thanks for the help
