Excel Table issues

[JR-BejeweledOne]

First time using an Excel data source.  This is just a temporary app to do some manipulation of the data.   I have an Excel file on my local drive that has 41K rows.    I can select the file and import it using the Excel connector but it's only bringing in 15000 rows.

How do I get to see all the rows?

[Drrickryp · Accepted solution]

@JR-BejeweledOne 

See my blog post here as to how to do this.  https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Automatically-Prefill-City-and-State-u...