We are using BI Connector v2.4.x including latest v2.4.3, with SSRS for structured reporting purposes.

When we try to use a parametrized SQL query in SSRS, where values in the "where" clause are dynamically set, the parameters are not evaluated by the BI Connector.

For example, in SSRS we set a query like:

SELECT *

FROM my_collection

WHERE id = @selected_id

@selected_id should be evaluated by the ODBC connector, but is accepted as is, and thus returns no data.

This exact same scenario and SSRS query works fine with the CData MongoDB driver/connector, so we strongly suspect it's an issue with the BI Connector.

It is possible that under the covers a prepared SQL query is being used, but that the BI Connector does not support prepared queries with their attendant value binding.