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...
Are you running a custom query or are you applying the RangeStart/RangeEnd filter later in the Power Query transforms?
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.
Is it possible to show me how to apply the parameters directly in the ODBC call also can you inform me how can i make inclusive and exclusive parameters. Actually i'm not professional in PBI
