This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi, I am trying to set up a query from a large data source (200000 entries) however cant apply any filters in the query as they are only looking within the first 1000 rows of data. The data source is an excel sheet which contains the results of a query pulling from a SAP type system.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Andreas, that seems to be working now, I also discovered an issue with the data type between numbers / text which i think may have been exacerbating the issue but this has really helped solve it thanks!
Unfortunately the MCode isnt picking up any entries outside the first 1000 lines and as such isnt letting me add the filter criteria.
Again: That's just a visual issue on screen!
Set a filter to something to get the MCode, then modify it:
Andreas.
Unfortunately the MCode isnt picking up any entries outside the first 1000 lines and as such isnt letting me add the filter criteria.
large data source (200000 entries) however cant apply any filters in the query as they are only looking within the first 1000 rows of data.
That's wrong.
You can see 1000 rows on screen, yes, because the PQ editor shows a preview only, but the MCode process the whole data. In these cases you have to write/adapt the MCode yourself.
Andreas.