Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connect to parquet and then filtering data by scripting?

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.