Power query trying to convert text to number unintentionally

[Justas4478]

Hi, I am working on migrating my reports to a sharepoint based storage.
unfortunatelly, one of the product codes for no reason is trying to convert in to number in power query, even when column type is changed to text.
That does not happen to the same product code when it is pulled from normal network drive.

For some reason it is trying to convert to number despite having text type.
I dont know why it is doing that.
Usually those problem dissapear when I cahnge column type from number to text, but this is first time I am getting this.
I think it has to do something with file being stored on sharepoint, if anyone has any idea how that can be a problem, please let me know.
I tried to change column type in file to text in sharepoint but that did not solve it.

[Justas4478 · Accepted solution]

Found what is the problem, Transform file from the query was forcing int type on the column.
I had to change it to text and that fixed it.
I am just unsure why later changes to column type were not overwriting that one data point.