I am working on an issue where it seems that Tableau does not pass any filters to the (live) database query after adding a filter based on MAKEPOINT spatial function, not even when the filter has hardcoded point values (leading me to think this is not data-related)
So simply put: i have a calculated field, say [Distance] = DISTANCE(MAKEPOINT(52.01, 4.01), MAKEPOINT(52, 4), 'm')
when i add to the filter pane, tableau then removes any other filters from the query to the live datasource (SQL Server)
is this known behaviour? It causes long-running queries as Tableau retrieves (way) too much data, as our context filters are trying to prevent that.
Haven't seen it before - and could not recreate it
please post your TWBX so we can see what is going on - gladly look into it
thanks
Jim
