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

that's not what I meant. How is MongoDB expecting it to be formatted?  Can you show a sample SQL query?

KareemMostafa12's avatar
KareemMostafa12
Helper I
3 years ago

Is it what you mean

 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Yes. Change your Power Query to 

     

    DateTime.ToText(RangeStart,[Format="yyyy-MM-dd'T'HH:mm:ss'Z'"])

     

    and the same for RangeEnd.

    • KareemMostafa12's avatar
      KareemMostafa12
      Helper I
      3 years ago

      where can i add this statement exactly?

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago
        let
    Source = Odbc.Query("dsn=MongoDB", "select * from groupshops where [createdAt]>='" & DateTime.ToText(RangeStart,[Format="yyyy-MM-dd'T'HH:mm:ss'Z'"]) & "' and [createdAt]<'" & DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd'T'HH:mm:ss'Z'"]) & "'")
in
    Source