Forum Discussion

Alkhos's avatar
Alkhos
Advocate I
9 years ago
Solved

DataFormat.Error: We couldn't parse the input provided as a DateTime value.

Hello,   I am working with a dataset retrieved as a CSV file through web. I have a time field on the dataset with values similar to below:          10/31/2016 4:05:00 PM   When data is fed to P...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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 .....

     

     

     

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

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 .....

 

 

 

Rawan's avatar
Rawan
New Member
2 years ago

Thank you for your previous explanation. I'm encountering a similar issue with my Power BI project that's connected to SharePoint. I rely on SharePoint to feed data into my dashboard.

I've successfully created my dashboard, but when attempting to upload an Excel file with the same template used previously in SharePoint and then refreshing my Power BI dashboard through Transform Data > Refresh, I encountered the following error: "DataFormat.Error: We couldn't parse the input provided as a Date value."

I double checked that the date data type in the new file matches the one in the file I initially uploaded when creating the project. Should I replicate the steps I took in Power BI previously to integrate the new Excel files into my existing project?

 

Thanks in advance,

 

Rawan