Power Query import text file from folder error



Iam trying to import text file from folder in power query . My text file is having 4000 rows when i try to combine & load through custom separator | it's showing error as "value duration was either too large or too small for timespan"

Can anybody sugggest how to resolve this issue please.



Hi Anil and welcome to the Forum.

I have no experience of this error (and searches don't produce anything helpful). Does the error occur if you try the same power query on a smaller data set (say 100 records) or with a different custom separator?
John_Ru (rep: 1267) Mar 23, '21 at 6:11 am
Tq John.

Yes john i tried with 100 Rows Data but still its showing same error. I have attached screen shot below. Can you please check and get me out of this.

Anil Kumar Mar 31, '21 at 11:31 am

Thanks for the reply but you can't acttach screenshots (only Excel files are allowed, added to Questions and Answers).

Sorry but I can't help you.
John_Ru (rep: 1267) Apr 1, '21 at 2:06 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login