Get and Tranform only loading 10 rows

%3CLINGO-SUB%20id%3D%22lingo-sub-201103%22%20slang%3D%22en-US%22%3EGet%20and%20Tranform%20only%20loading%2010%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201103%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%20Get%20and%20Transform%20to%20load%20data%20from%20another%20excel%20workbook.%20My%20dataset%20in%20the%20excel%20has%20about%2030%20columns%20and%201500%20rows.%20I%20use%20the%20%22New%20Query%20-%20from%20workbook%22%20and%20selects%20my%20workbook.%20It%20then%20displays%20a%20%22Navigator%22%20window%20which%20shows%20the%20sheets%20in%20my%20workbook.%20When%20I%20select%20the%20sheet%20I%20wanted%2C%20it%20loads%20a%20preview%20window%20with%20only%2010%20rows%20and%203%20columns.%26nbsp%3BI%20then%20select%20%22Load%22%2C%20it%26nbsp%3Bloads%20the%2010%20rows%20into%26nbsp%3Bmy%20new%20workbook.%20It%20is%20always%26nbsp%3Bloading%20only%2010%20rows%20and%26nbsp%3B3%20columns.%20I%20thought%20it%20was%20only%20showing%2010%20as%20preview%20and%20will%20load%20all%20rows%20when%20I%20say%20Load%2C%20but%20that%20is%20not%20happening.%20I%20tried%20%22Refresh%20All%22%20also%20and%20it%20refreshes%20that%2010%20rows%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20pulling%20the%20data%20from%20a%20website%20URL%20using%20the%20same%20way%20and%20in%20this%20case%20also%20I%20am%20getting%20only%2010%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20any%20other%20settings%20that%20I%20am%20not%20aware%20of%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERajesh%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-201103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203090%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20and%20Tranform%20only%20loading%2010%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203090%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20tried%20saving%20the%20workbook%20as%20a%20CSV.%20My%20guess%20is%20there%20is%20a%20problem%20with%20the%20Excel%20file.%20Try%20copy%20paste%20the%20data%20in%20a%20new%20file%20and%20see%20if%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-203062%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20and%20Tranform%20only%20loading%2010%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203062%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%20do%20you%20have%20the%20origen%20file%20to%20share%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I am using Excel Get and Transform to load data from another excel workbook. My dataset in the excel has about 30 columns and 1500 rows. I use the "New Query - from workbook" and selects my workbook. It then displays a "Navigator" window which shows the sheets in my workbook. When I select the sheet I wanted, it loads a preview window with only 10 rows and 3 columns. I then select "Load", it loads the 10 rows into my new workbook. It is always loading only 10 rows and 3 columns. I thought it was only showing 10 as preview and will load all rows when I say Load, but that is not happening. I tried "Refresh All" also and it refreshes that 10 rows again.

 

I tried pulling the data from a website URL using the same way and in this case also I am getting only 10 rows.

 

Are there any other settings that I am not aware of ?

 

Any help appreciated.

 

Thank you,

Rajesh

3 Replies

hi, do you have the origen file to share it?

Have you tried saving the workbook as a CSV. My guess is there is a problem with the Excel file. Try copy paste the data in a new file and see if it works.

Did you manage to figure out why this was happening? I'm having the same issue.