wrong import of data

Jolyon

I have tested it on my site and was not able to reproduce this issue (I can import the right data without losing the point).

In this scenario, we can still add the point back to the Product-ID column using Query Editor.

First, change type of Product-ID to Text.

Then paste the formula below into Advanced Editor.

    #"Split Column by Position" = Table.SplitColumn(#"Changed Type","Product-ID",Splitter.SplitTextByPositions({0, 2}, true),{"Product-ID.1", "Product-ID.2"}),
    #"Added Suffix" = Table.TransformColumns(#"Split Column by Position", {{"Product-ID.1", each Text.From(_, "en-US") & ".", type text}}),
    #"Merged Columns" = Table.CombineColumns(#"Added Suffix",{"Product-ID.1", "Product-ID.2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Product-ID")
in
    #"Merged Columns"

Click Done, then you will see the point has already been added.

Regards