Connect to parquet and then filtering data by scripting?

[mister_tsvd]

Since Parquet file size is quite big, but user wants to filter data similar to connecting to SQL server, then add a filtering script i.e. "where sth like %xxx%". Is there a way to do similar thing like that in Parquet connection?

Note* I don't want to filter data by using PowerQuery since PowerBI's going to load all data first, it took a lot of loads and reduce performance when report has been published.

[lbendlin]

python - Using predicates to filter rows from pyarrow.parquet.ParquetDataset - Stack Overflow