Forum Discussion
Solved
Power query not loading all columns of a CSV
Hi, I am using Power Query to manipulate data from a CSV. This CSV has many columns (5913) and only a couple of rows (4). As you might imagine, one of the first things I want to do is transpose the ...
Strangely, I may have fixed this. Firstly, a screenshot showing that my last column was the 2671st column.
I then clicked on the source, changed it to read it as a Text file rather than a CSV, then changed it back to CSV. Voila, all 5913 now appear. No idea why but posting here in case of use to others.
Strangely, I may have fixed this. Firstly, a screenshot showing that my last column was the 2671st column.
I then clicked on the source, changed it to read it as a Text file rather than a CSV, then changed it back to CSV. Voila, all 5913 now appear. No idea why but posting here in case of use to others.