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...
Hi Ibendlin!
Yes my target column is also [CreatedAt] same as you mentioned in your code and i replaced with this code but when i click Done it gives this error message
Good, making progress. What format does MongoDB expect for date or datetime fields? Is "2023-01-17" enough?
it is date/time field firmat as shown in the photo
that's not what I meant. How is MongoDB expecting it to be formatted? Can you show a sample SQL query?
Is it what you mean