Forum Discussion

FatiFlaubert's avatar
FatiFlaubert
Icon for Helper I rankHelper I
5 years ago
Solved

Restore the Months format

Hi everyone, In the imported file (Excel) I have a column for Months (January, February..) but once on Power BI I got a column with numbers (Ex : 44013). Do you have any idea of what should I do to...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    Edit the step in power query and remove the conversion

FatiFlaubert's avatar
FatiFlaubert
Icon for Helper I rankHelper I
5 years ago

The  data type in pbi is Text ! while in Excel is Date. I really don't understand why it does convert once uploaded on PowerBI ..

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

Edit the step in power query and remove the conversion