Forum Discussion
Power Query table range
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?
11 Replies
Usually Power Query takes as source structured table or named range. If the latest check in Name Manager how the name is defined and correct if necessary.
- Yes, thank you, I am aware of this table and have tried to resize it. I must be missing something because when I try to change the range in the resize table box it does not correct my issue.
That's straightforward operation
and you always may check in Name Manager what is the actual size.
Presuming there's no blank rows within the data and that the data on the sheet is contiguous...
If I'm not mistaken, PQ determines the row count by reading the dimensions from the sheet's XML. For example:
One way to get the dimensions to update is to simply open the workbook, save it, close it, and try the import again.
- I have tried to open save and close multiple times, unfortunately.
