Incrimental Refresh for MongoDB ODBC Connector

andreikrasnou · ‎05-03-2021

Hi,

I'm trying to enable incremental data refresh for MongoDB data source. I've configured BI Connector and ANSI ODBC driver version 1.4.

However, when I'm trying to refresh my power query I'm receiving such error.

Could you please advise what can be wrong? Or ODBC Driver simply doesn't support incremental refresh? In that case is there any workarounds?

Thanks!

andreikrasnou · ‎05-06-2021

@Anonymous

I've checked this doc. What I can see from the requirements Date column is definitely supported by my datasource (MongoDB) . Speaking about Query Folding it is hard question. Mongo supports queries by dates in any complexity. However, when I'm trying to add filter by date odbc driver error appears. But in the same time for example filter by string value works fine.

I'm not sure to whom address this question. Maybe to ODBC driver maintainers?

Anonymous · ‎11-30-2021

Hi @andreikrasnou,

Did you manage to go further implementing incremental refresh with MongoDB using ODBC ?

I have a MongoDB database, with mongosqld (their BI connector) on which i connect with the MongoDB ODBC Driver, and i'm having a hard time making it work.

From what i understand there are 2 ways to import a table :

- use ODBC and provide a SQL statement, this operation needs to be performed for every table you want to import. Incremental refresh is useless here because power query will execute the whole query and only then will filter the result (on power bi's side). This works BUT DOES NOT bring any increase of performance at all.

- use ODBC and select the table you want to import graphically, like you most likely did because i have the same exact error as you do. I think this problem is because this feature is not implemented in the ODBC Driver.

Since mongosqld is just a mysql gateway to MongoDB, perhaps it's worth trying to use the mysql ODBC connector. I'm trying to do this but unlinke MongoDB ODBC connector, it requires SSL to be setup on mongosqld.