Filter column on a table based on Direct query

Question & Answer
, ,
1

Hi,

I have a dashboard that retrieve information(direct query) once the user add the information they want to check through the available Controls. This is working perfectly.

This information is visualized once the results are ready in a table. I would like to add some filters(controls) so once the table is ready users can filter and find some specific rows. However, creating this filter->control in the normal way does not work. The filter does not recognize values from the different columns.

Is this because I am using direct query?

What I would like to do is once I have the table ready just filter some rows from that table, without retrieving data again via Direct Query. Is this possible?

Thank you!

2

Hello @jgrueso

When using Direct Query, every time a filter is applied, the dashboard makes a new query to the underlying data source. This is likely why your filters aren’t working as expected, they are trying to retrieve new data rather than filtering the already displayed results.

If possible Switch to SPICE, load the dataset into SPICE. When using SPICE, filters applied after the initial load do not trigger additional queries to the database but filter the already loaded data.

Hope this helps!

1 Like