Date formating from excel to power BI showing an error

[vsss]

Hi,

When i am importing data from Excel to power BI i am getting an error. 

Have tried changing the format in Power BI to date/time but still getting the error. 

[v-yuta-msft · Accepted solution]

@vsss ,

I could not reproduce this issue, the data type in excel is general and after imported, the data type has been converted to Date/Time in power bi as below:

 

Community Support Team _ Jimmy Tao

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

[mahoneypat]

Try leaving it as text first. Use text before delimiter button under Extract on Transform tab, and space as the delimiter. Then converte to date. 

Regards

Pat