Forum Discussion
Power Query automatically changes text to number
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
Anonymous , 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
1 Reply
Anonymous , 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