Forum Discussion
Does slicer choice on direct query table visual automatically triggers a new direct query execution?
I have made a table visual and two slicers. The first slicer selection automatically triggers a dynamic direct query using a parameter.
I added a second slicer with the purpose to filter the returned data from the direct query but it seems to me that this slicer selection also triggers a another direct query execution. That was not my intention.
If this is correct observed, I would like to know how I can apply my second slicer to filter the returned data from the direct query without trigger another execution.
Absolutely. Every single user interaction with your visual (or other visuals that may impact your visual) WILL trigger a new query against the data source. That's the purpose of Direct Query.
1 Reply
- lbendlin
Super User
Absolutely. Every single user interaction with your visual (or other visuals that may impact your visual) WILL trigger a new query against the data source. That's the purpose of Direct Query.