Forum Discussion

KareemMostafa12's avatar
KareemMostafa12
Helper I
3 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

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.

KareemMostafa12's avatar
KareemMostafa12
Helper I
3 years ago

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

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Show a sanitized version of your Power Query code.  You can see the code by selecting  "Advanced Editor"

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        something similar to this

         

        let
    Source = Odbc.Query("dsn=MongoDB", "select * from groupshops where [createdAt]>='" & RangeStart & "' and [createdAt]<'" & RangeEnd & "'")
in
    Source