MongoDB ODBC Driver - Power BI's Power query filter

I am using MongoDB ODBC Driver 1.4.2. I am using this driver to connect Microsoft Power BI report to mongosqld (MongoDB connector for BI).

It works all fine except for one part : when i try to implement a Power Query custom filter, i get the following error :

“Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [MySQL][ODBC 1.4(a) Driver][mysqld-5.7.12 mongosqld v2.14.0]This command is not supported in the prepared statement protocol yet. '.”

It looks like this feature (query folding) is not implemented on the driver’s side (or maybe on mongosqld’s side ? i’m not sure).

My questions being :

  • is there any work-around to have this work ?
  • or is there a soon to be released upgrade implementing this ?

Thanks

1 Like

Hi Mathias,

I have the same issue here, did you find a solution?

Best Regards,

Ciro

Hi Ciro,

There is no solution for this with this approach. I see there was a release for mongodb odbc driver 1.4.3 three weeks ago but i doubt this fixes anything regarding power bi incremental refresh and query folding.

Another approach is to use CDATA mongodb odbc driver.

Best Regards,
Mathias