We couldnt Convert to Number but its text

[DebbieE]

I have a Property Number in my SQL Data base. Some of them have hyphens 1045-1 etc but its fine because its string.

In Power BI Ive kept it as string

However when I keep refreshing the reports  I get errors that go into an errors table and property Number with hyphens are error

DataFormat.Error: We couldn't convert to Number.
Details:
2353-1

I dont understand why this is happening because I dont want it to be converted to a number. There is nothing converting in Query Editor that changes Property Number  to Number. I dont know what to do to solve the problem?

[DebbieE · Accepted solution]

Ive sorted it

It has originally been a number so I had to go into Advanced Editor and change it there

{"Property Number", type text}}),