Forum Discussion
Incremental refresh for MongoDB database
Will be happy if someone can help me 😔 i'm using MongoDB connected with PBI with BI connector to using ODBC DSN and every thing is working fine till now recently i tried to setup incremental refre...
I'm just applying RangeStart/RangeEnd filter later in the power query
May be that the query folding is not working properly for MongoDB. Apply the parameters directly in the ODBC call.
NOTE: one of the parameters must be inclusive and the other must be exclusive. Otherwise you end up with gaps or overlaps between partitions.