Limit data on import

First, delete the Filtered Rows1 step. It is doing nothing.

As to why your query is laggy, not sure. The filter should be folding to the server. When I created a filter to limit it to the last 15,000 days (just messing around) I can right-click on that filter and View Native Query has this in it:

...
where [_].[Due Date] >= convert(datetime2, '1980-06-12 00:00:00') and [_].[Due Date] < convert(datetime2, '2021-07-07 00:00:00')

So the server is filtering the data. For you it should be just doing 35 days.

I am not sure what the next step is doing. It might or might not fold but you cut it off.  This is not a valid statement:

Table.AddColumn(#"Filtered Rows1", "Custom", each if Text.Contains([PLCSHORTTAGNAME], "F1.vaI_Iavg")

You are missing a closing paren

You cannot have an if statement without both a then and else clause. Text.Contains is folding, but what is in your then/else clause might not be.

However, your query should be folding through the filtering, so if it is laggy, then even for 35 days, you may have millions of records.

Make sure your column profiling at the bottom of your screen says 1,000 rows, not "all data."

To help further, we'd need to see the full formula in the Table.AddColumn() step, as well as know if your filter is folding. Again, right-click on it, and see if View Native Query is available.