No data shows after applying a Row filter using Advanced Editor

[ialayidi]

Hello, 

I'm using an ODBC connection and have a table with over 13 million rows. I only need to analyze a certain category named Rework. The preview does not load due to size of table. I can apply the row filter manually through Advanced Editor, however; it is not giving me any rows, nor is there any error! The main objective here is to reduce the refresh time. Please help! Thanks! 

Code: 

= Table.SelectRows(TRANSLOG_Table,each ([LOC_DESC]) = "REWORK")

[Kaviraj11]

Can you create another subset table of this and distinct the LOC_DESC column and see the actual value?

[ialayidi]

It keeps thinking for over an hour without a status... 

[Kaviraj11]

Can you try with Contains and make sure it's case sensitive:

= Table.SelectRows(TRANSLOG_Table, each Text.Contains([LOC_DESC], "Re"))

[ialayidi]

It took forever to run the code, and gave me the same result as using "REWORK"