Power Query : Limitation on size of data?

[orangebloss]

Hi

Is there a limitation on the number of cells you can import? I have a file with 209 columns and 500 rows but PowerQuery is only bringing in the first 128 rows - is there a workaround to this?

Many thanks

 

[Norie]

I just loaded a range with 408 columns and 836 rows into Power Query with no problem.

Did you check your entire range was included when you tried it?

 

[DavidT77]

Are you sure you aren't looking at the sample data screen? I regularly use PQ to import 300,000 - 400,000 rows of data in one of my workbooks. It takes it a while, but it works effectively.