Power Query automatically changes text to number

[minhduc_nguyen]

Hi, I have a table as below with the first column stating Period with abreviations of the months

But when importing the data into Power BI the first column with the abreviations of months was turned into some numbers as below

Is this an error or did I do something wrong? Appreicate any helps thanks in advanced

[amitchandak · Accepted solution]

@minhduc_nguyen , I doubt you excel has date where you have shown the month value, they are not of text type.  That is why it converting it like this in power BI