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 work...