Is there any limit for Excel get Worksheet as a range action?

[sai_bhargavaraj]

Hi All,   I have an Excel sheet where i'm performing some refresh operation with Power queries. After performing refresh i am reading the entire sheet as collection. My Excel sheet may contain data over 5000 rows. while performing this step BP is getting hanged. Is there any range limit for BP to collect from Excel?    Please guide me if you have faced this issue.   Thanks in advance  

[AndreyKudinov]

Depends on number of columns too, but 5000 should be fine. You start getting out of memory exceptions when you hit the limit.

[david.l.morris]

I've dealt with pulling 10,000 rows from Excel before without error but the limit may be affected by the number of columns as well. I've seen some people hit a 'seeming' limit at 4,000 but I'm not sure what the details were there.

[OliverMohajeri]

If I remember correctly, columns is a bigger drain on memory than rows. if possible, delete any columns you don't need before retrieveing the information (You could design a macro to do this and then call it using the VBO object).