cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Date is not recognized

 

Hi team , 

 

I have Date and time in excel , after i upload into Bi , Date and time displayed to number instead. While i tried to transform to Date format , I changed at Data Modeling , Quries , it appeared error . No idea how to fix this. 
Anyone can tell me how to settle this ? i also tried Split column. 
3.PNG

1.PNG2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Date is not recognized

Hi @Chanleakna123,

 

In your Query Editor, please remove first 4 rows which have null values. Then promote the first row as header via "Use first row as headers" button. Then select the Date/Time Receive column, change Data type as Date. 

 

If above doesn't work, please share the source file and pbix file with us. 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: Date is not recognized

Hi @Chanleakna123,

 

In your Query Editor, please remove first 4 rows which have null values. Then promote the first row as header via "Use first row as headers" button. Then select the Date/Time Receive column, change Data type as Date. 

 

If above doesn't work, please share the source file and pbix file with us. 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Re: Date is not recognized

@v-qiuyu-msft thanks , it works well . that's why i love Power BI Community ^^

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)