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...
Yes the confusion may be on my parts because this is not my strong area. It's almost like there is a limit of rows that are filtering. I am not 100 % sure on this so any guidance would be appreciated.
Well, only way to help you further would be to see the query code at least. Ideally share the workbook (via OneDrive, Google Drive or the like if you can't attach it here) with the data you pasted today (or dummy representative if it's sensitive)
For the query code go to:
- Data (tab) > Queries & Connections
- Right-click on the query name > Copy
Paste the code in a reply, if possible using the Insert/Edit code sample button of the toolbar (Power Query in the list: