Working with partitioned data

[Anouk]

Hello,

I would like to work with partitioned data but I keep receiving the same error:

Unable to retrieve a fields list from the table Node_data: ERROR [42000] [Qlik][BigQuery] (70) Invalid query: Cannot query over table 'node_activity_dsi.Node_data' without a filter over column(s) 'date' that can be used for partition elimination

 I've tried several filters but cannot make it work. 

Thank you in advance for your help

[Eugene_Sleator]

Do you have the 'require partition filter' set on you BQ table..node_activity_dsi.Node_dat

[Anouk]

Yes I do have the require partition filter on the BQ table.

[Eugene_Sleator]

refer to this 

Qlik Sense BigQuery connector: Unable to retrieve a field list from the table Products_View: ERROR[H...