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

    I think i'm doing something wrong 

     

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Can you get the SQL query to work with the same datetime values?  Maybe the expected format is different, or without single quotes etc.

  • KareemMostafa12's avatar
    KareemMostafa12
    Helper I
    3 years ago

    I will contact database team and to try changing SQL format and will feedback you. thanks for your patience 😊

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi KareemMostafa12 ,

     

    Is there any update on the issue?

     

       

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • KareemMostafa12's avatar
    KareemMostafa12
    Helper I
    3 years ago

    Still not solved i'm trying to find a solution with my database team to chage date formate