I have a small table in Bigquery less than 20 Mg, it is partitioned per date and has a cluster on 1 field and it does require filter Partition.
when i create a reservation, and connect using datastudio, I get the error is that the query is not Powered by BI engine, as the table has a big size ( which is not true).
what's causing the problem, is it the filter partition ?
sorry, it was a bug in BI Engine, fixed now
edit: it was a bug in BI engine, https://issuetracker.google.com/issues/140507651