Forum Discussion
Anonymous
6 years agoNot applicable
Loading a .Txt Delimited source, the max Rows hit a 244,265 limit, when the file has around 330K.
Hi All, So loading a .txt source in PBI with the only delimitation piece, no further transformation done to it, only gets me 244,265 rows instead of the full 330K within the file. Tried loading it d...
edhans
Community Champion
6 years agoInteresting, and clever thinking on the workround. I've never seen that happen. I would think a delimiter is missing. If you did split by position, I wonder if a space (char 32) is really a non-breaking space (char 160). Visually you cannot tell. And if splitting by position it won't matter, but if it is parsing based on using a space as a delimiter, it won't work, and may cause the issue you see.
Also weird that NotePad++ woudn't open it. I opened that 1.5M record fake credit card data on my machine in less than 3 seconds, but that file has very few fields, only 139MB. Your file might be larger even though it has fewer records.
Anonymous
6 years agoNot applicable
Yea, really weird, the .txt file is 468mbs