Text data type displaying as number

[ZedLeb]

I've got some codes with leading zeros which I have set as text in the Query Editor.

= Table.TransformColumnTypes(#"Expanded MASTER Template Dupes",{{"Matl Grp Pack. Matls", type text}, {"Transportation Group", type text}})

The column view confirms that the data type is Text and there is no sigma against the Field name however the R Data Table view is presenting data in these two columns as numbers.

Any ideas what might be happening?

[deldersveld]

The API for R visuals does not expose data type and formatting like we can get with regular custom visuals. If it looks like a number, R treats it as a number.