Get and Tranform only loading 10 rows

Copper Contributor

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.