cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MAAbdullah_47
Helper V
Helper V

We couldn't parse the input provided as a Date value.

Hi , Please check the below screen-shot:

 

MAAbdullah_47_0-1631970673497.png

 

I made a changes using Query editor , there was no errors on the columns of the Table , but when I try to apply the changes everytime I got this message :

 

OLE DB or ODBC error: [DataFormat.Error] We couldn't parse the input provided as a Date value.. An unexpected exception occurred.


Finally I changed all the dates fields into Text to avoid the error message , but unfortiently I got the same message , please I need your help.

 

4 REPLIES 4
v-janeyg-msft
Community Support
Community Support

Hi, @MAAbdullah_47 

 

Is your problem solved?

I don’t know what changes you made, it may have caused an irreversible error, causing the loading to fail.

You can click on the steps step by step to see if the problem starts to occur in a certain step.

You can also try to re-import the data source. If you still can’t solve the problem, please share the query code in PQ.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.


Best Regards,

Community Support Team _ Janey

 

moizsherwani
Helper V
Helper V

This is a type conversion error but without looking at the power query steps it is difficult to tell you exactly what the solution will be. You could try to add a "Remove errors" at the end which will remove the erroneous rows but of course this won't be the ideal method since I am assuming you don't want to lose data. Also in my experience the data being displayed are only the first 1000 rows whereas the error might be in a row below so if you select "Column profiling based on the entire dataset" and use the drop down to try to scroll and see if you can identify something which doesn't look like a date. If none of these help then having a look at the problem via screenshot is probably the way to go.

Hi @moizsherwani  thank you for your response , I changed all the dates into text , and still the message displayed ??! If there is a problem in the date but on the current stage I changed it back to (Text) not date , Why it still continue display the error although I change it from Date to text? 

You have done the right thing but unforutnately I can't help further without actually looking at the query.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors