Excel data - dates are turned into chinese characters when transferred into power bi ??

[Anonymous]

Hi

I'm a bit of a new user to Power BI, just entered my data from excel and for some reason the delivery/loading date column name are translated into Chinese character - and i just don't understand wHy - have tried to fix language, formatting etc. What's going on? Bug? anyone faced this? Any help or suggestions please thank you!

[Anonymous]

Hi Kishore, thank you for advise/help!! it's excel, tried to amend formatted colums/table etc. No special characters, tried two versions tried both still get the chinese characters for delivery date, year, month. I don't have an option to attach sample. It does work if i download the program on my desktop, but not in the online version.

[Anonymous]

Excel as in xlsx

[Kishore_KVN]

Hello @Anonymous , what is your data source is it xlsx or csv. If csv change to xlsx first. Then see if there are any special characters before the name in the dates column headers. If not delete those cells and rewrite them in those cells in Power Query. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

If you still face issue, please share your sample excel data as attachement here to check.