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...
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.
