Power BI, get Excel Data automatically convert Date Time (yyyy/mm/dd hh:mm:ss) column to whole number

0
votes

I want to import excel file to Power BI Desktop, using the Get Data (Excel) feature. I have a column with a datetime format as you can see below:

Excel Column

When I imported the excel data to Power BI, it automatically converted the column to a different format (not datetime or text), as attached below:

Imported Column

What changes should I make in the settings to make Power BI identify this column as Datetime or Text?

1
powerbipowerbi-desktop

1 Answers

0
votes

Apparently, you can just change the column data type to the desired type after loading the excel. But it'd be great if you can set to load the column as it is