I am using a power query at work that someone created before me. I paste the data I want to analyze into a tab within the worksheet and select the refresh button. The data I pasted today has 552 rows. When I look at the queries and connections it is only using 489 of these rows. How do I change the range it is pulling from?

​I am using a power query at work that someone created before me. I paste the data I want to analyze into a tab within the worksheet and select the refresh button. The data I pasted today has 552 rows. When I look at the queries and connections it is only using 489 of these rows. How do I change the range it is pulling from?  Read More

​