Forum Discussion
Dynamic M query Selection
Hi All, At the moment I am using Dynamic M queries within my SQL querie which is in Direct query mode. The rest of the tables which I am using are in import mode. The Dynamic M query works fine w...
Is it possible to have multiple parameters in your SQL where clause Parameter?yes but it is your responsibility to sense if the parameter is coming in as scalar value or as list (via Value.Is ) and to modify your SQL query accordingly.
When is a parameter excatly changed and is the Direct query fired?when a user interacts with your report in a way that requires a recalculation of that query.
In addition to my question I found out that you should put the slicers on the same page as your direct query will be fired. You can hide them and use sync slicers if you make selections on a different page, but it is needed.