Carol Morris
New Member
Members
Forum Posts: 1
Member Since:
April 12, 2016
April 12, 2016
Offline
Hi, I have a series of files that I combine using Power Query, they have 209 columns each and vary in row size. I've discovered that one of them (with 500 rows) is only importing the first 128. I'm assuming that this is something to do with the maximum amount of data you can import?
More importantly I need a workaround either:
1. To be able to import all the data
or
2. To be able to remove columns not required and then refresh the preview to return all the rows (I've tested this and it returned all the rows when I deleted some columns but not sure how I can do this in the script?)
Help much appreciated!
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Robert Primmer
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michal Kučera
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Forum Stats:
Groups: 3
Forums: 24
Topics: 6881
Posts: 30160
Member Stats:
Guest Posters: 49
Members: 33708
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —