Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

  • 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.