Error in query editor when extracting part of string and converting to number in same step

[Anonymous]

Hi,

The following query generates strange behavior both in the latest version of PBI desktop and in excel:

let
Source = #table({"FaseID"}, {{"0. N/A"}, {"1. Ide"}, {"2. Valg av løsning"}, {"3. Utvikling"}, {"4. Utrulling"}, {"5. Avsluttet"}}),
#"Inserted Text After Delimiter" = Table.AddColumn(Source, "Fase", each Text.AfterDelimiter([FaseID], " "), type text),
#"Inserted Text Before Delimiter" = Table.AddColumn(#"Inserted Text After Delimiter", "Sortering", each Text.BeforeDelimiter([FaseID], "."), Int64.Type)
in
#"Inserted Text Before Delimiter"

When the query is loaded I get an error message, but when I try to view errors, none are found.

If the datatype is changed in a seperate step, it works as expected.

[v-qiuyu-msft]

Hi @Anonymous, 

The same issue has been reported before internally: CRI 99463806. Please see my last response in this same thread: https://community.powerbi.com/t5/Issues/Table-AddColumn-type-mismatch-should-throw-error-or-warning/idc-p/597620#M36992

Best Regards,
Qiuyun Yu