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

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
    • KareemMostafa12's avatar
      KareemMostafa12
      Helper I
      3 years ago

      should i copy this code to the advanced editor box?

      • KareemMostafa12's avatar
        KareemMostafa12
        Helper I
        3 years ago

        I tried to copy/paste this code in Advanced editor but gives error. Will be happy if you can inform me how to add this code?