Get and Tranform only loading 10 rows

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