Adding a Slicer to a pivot table of a Bigquery Connected Data Source

[chirinek]

Hello!
I have a sheet which is sourced from BQ using Data connector, on which i have applied a pivot table:

When trying to add a slicer to the pivot table and using the connected data as the data range, i get the corrected list of columns, but unfortunately, when i choose a column, it doesn't display the available values on which i can filter on ("Filter on values"), i only get the "Filter by condition" option:

In case i create an extract of the retrieved data, it is limited to 100k rows whereas my data is bigger than that.

Can anyone please advise on a possible solution to that?

Thank you!