Forum Discussion
Query Won't Load All Rows
I've seen many topics and tried many solutions and still can't find the answer. Here's a plain text CSV. When trying to query it cuts off after around 1100 rows. I've tried this with multiple files a...
Downloaded your TXT file and applied the following M-code. It created a table with 4617 rows.
let
Source = Table.FromColumns({Lines.FromBinary(File.Contents("........................../KBVA Songs.TXT"), null, null, 65001)}),
#"Split column by positions" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByPositions({1, 7, 12, 83, 124, 126, 127, 133, 135, 137, 138, 144, 146, 148, 149, 155, 163, 165, 166, 172, 180, 182, 183, 189, 197, 207, 218, 228, 238}))
in
#"Split column by positions"Connect with PQ to TXT/CSV and then set the separator to 'nothing'. Then you get all texts in one column. Now split the column based on positions. Done.