Power Query import text file from folder error

0

Hi,

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.

Answer
Discuss

Discussion

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
Anil

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