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