Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a DateTime value.
After playing with your text file for 15 mins, I have found that there are some extra space at the front of your date column. Can you please remove those extra characters.
Steps to follow afterwards:
1. Split the column by 11 characters. This will separate Date and Time
2. Split the Date column by "/" Delimiter
3. Change the data type of the newly created columns to Whole number
4. Bring the Day column first by dragging, Month column second and Year column last
5. Select all these three collumns and go to Add column Tab, Select Merge Columns and in Merge dialog, Select "/"Separator.
6. Change the data type of the merged column to Date.
So many steps .....
After playing with your text file for 15 mins, I have found that there are some extra space at the front of your date column. Can you please remove those extra characters.
Steps to follow afterwards:
1. Split the column by 11 characters. This will separate Date and Time
2. Split the Date column by "/" Delimiter
3. Change the data type of the newly created columns to Whole number
4. Bring the Day column first by dragging, Month column second and Year column last
5. Select all these three collumns and go to Add column Tab, Select Merge Columns and in Merge dialog, Select "/"Separator.
6. Change the data type of the merged column to Date.
So many steps .....
Go to the Query Editor (right-click on the table in 'Fields' on the right-side, and select 'Edit Query').
Find the column with the date
Right click on column header and change type to Text
'Apply and Close' the query editor (left side top you should see this)
Now on the left side you should click on 'Data' and then in the 'Fields' on the right side click on the relevant table
Now go to the column which must be the date
Select the column by pressing on column header
in the 'Column Tools', change 'Data Type' to Date
Change 'Format' to your preferred date format
PowerBI is a *****