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...
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
Yes. Change your Power Query to
DateTime.ToText(RangeStart,[Format="yyyy-MM-dd'T'HH:mm:ss'Z'"])and the same for RangeEnd.
where can i add this statement exactly?