I'm trying to consolidate data from multiple csv files in excel sheet using Data-. New Query-.From File option.

However after doing "Combine and Load" data is not flowing completely in Excel.

Attached screenshot for your reference. You can see data is loaded only for 32 rows. However on the right side you can see that 430k+ rows are loaded

![](https://i.stack.imgur.com/28EFU.png)