DataFormat.Error MSO

[Anonymous]

All,

Need some help on a strange error I'm getting.

I have data imported from CSV file and want to group the data.

The grouping returns below error

My code has been running for over past 2 years without any issues and my input file is (as far as I can see) not corrupted.

During troubleshooting it appears that the problem seems to be related to the Key type of the grouping statement.

In below example:

Case "Priority" type is text -> no error

Case "Priority" type is Int64.Type or number-> DataFormat.Error

Table.Group(#"Changed Type1", {"ID", "Priority"}, {{"Duration", each List.Sum([#"Duration"]), type nullable number}})

Hope you can help me out.

[Anonymous]

Hi Ibendlin,

Double checked and indeed MSO was added at the end of the file as a new Priority.

Bit stupid that I did not check this. Was interpreting MSO as Microsoft Office.

Thanks for helping out.

[lbendlin · Accepted solution]

Does your CSV data contain a cell in the Priority column with the value "MSO" ?