Forum Discussion
Solved
Not all rows imported by Power Query from a fixed-width text file
I have a customer which has an issue related to Power Query. Let me explain the background: Today they import a fixed-width text file into Access. Then they import the data from Access into Power BI...
Anonymous looks like positions in fixed-width text. But this parameter should be
delimitercan be a single character, a list of characters, or the value"", which indicates rows should be split by consecutive whitespace characters. Default:",".
LucAppelmans i would try to use Lines.FromBinary instead of Csv.Document and then split text by positions. Just my 2 cents.
Hello, LucAppelmans to be honest I don't know why Csv.Document failed in your case. I can't find split by positions option here however PQ interface does allow to enter positions (smth new to me). Anyway I am glad Lines.FromBinary solved your problem. It worked because it is desined to "convert a binary value to a list of text values split at lines breaks". At least you get all your lines. 🥂
Anyway thanks for your feedback and help.