Home

Data Format Error: We couldn't parse the input provided as a Date value

%3CLINGO-SUB%20id%3D%22lingo-sub-753731%22%20slang%3D%22en-US%22%3EData%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753731%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%206%20different%20reports%20that%20I%20receive%20daily.%20I%20am%20trying%20to%20merge%20them%20using%20power%20query%20into%20one%20table%2C%20so%20that%20all%206%20of%20the%20reports%20(only%201%20row%20of%20data%20each)%20are%20combined%20into%20one%20row%20on%20the%20merged%20table.%20I%20keep%20getting%20the%20error%20message%3A%26nbsp%3BData%20%22Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%22.%20The%20Query%20connections%20seem%20to%20be%20fine.%20Then%20I%20add%20new%20files%20to%20the%20folder%20I%20am%20merging%20from%20and%20then%20I%20get%20that%20message%20when%20I%20go%20to%20refresh%20the%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!!!%20What%20do%20I%20need%20to%20do%20to%20fix%20this%20error%3F%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-753731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753874%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375958%22%20target%3D%22_blank%22%3E%40purpleorchid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20that's%20literally%20what%20the%20message%20says%20-%20in%20one%20of%20your%20files%20there%20is%20the%20value%20which%20is%20expected%20as%20Date%2C%20but%20can't%20be%20converted%20into%20the%20date.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754121%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754121%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20double%20and%20triple%20checked%20all%20data%20before%20I%20did%20the%20query%20and%20the%20query%20refresh.%20All%20date%20columns%20were%20already%20set%20up%20as%20dates%20on%20the%20original%20worksheets%2C%20before%20I%20even%20created%20the%20query%20and%20when%20creating%20the%20query%20I%20made%20sure%20to%20set%20that%20column%20as%20a%20date%20as%20well%2C%20so%20there%20was%20nothing%20that%20needed%20to%20be%20'converted'%20to%20a%20date%2C%20as%20they%20already%20were%20dates.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754898%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Format%20Error%3A%20We%20couldn't%20parse%20the%20input%20provided%20as%20a%20Date%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754898%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375958%22%20target%3D%22_blank%22%3E%40purpleorchid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20provide%20the%20sample%20keeping%20only%20column(s)%20with%20dates%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
purpleorchid
New Contributor

Hi, I have 6 different reports that I receive daily. I am trying to merge them using power query into one table, so that all 6 of the reports (only 1 row of data each) are combined into one row on the merged table. I keep getting the error message: Data "Format Error: We couldn't parse the input provided as a Date value". The Query connections seem to be fine. Then I add new files to the folder I am merging from and then I get that message when I go to refresh the query.

 

Please help!!! What do I need to do to fix this error? What am I doing wrong?

3 Replies
Highlighted

@purpleorchid 

 

Most probably that's literally what the message says - in one of your files there is the value which is expected as Date, but can't be converted into the date.

@Sergei Baklan I double and triple checked all data before I did the query and the query refresh. All date columns were already set up as dates on the original worksheets, before I even created the query and when creating the query I made sure to set that column as a date as well, so there was nothing that needed to be 'converted' to a date, as they already were dates.

@purpleorchid 

 

Could you provide the sample keeping only column(s) with dates?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies