Forum Discussion

Alex_Rajkov's avatar
Alex_Rajkov
Advocate III
7 years ago

Suddenly dataflow refresh error SqlDateTime overflow

Since this morning dataflow throws the following error while refreshing from MS NAV 13 via ODATA connection.   Invalid date,NAV ODATA TEST,Fehler,Verkaufsgutschriftszeile,12/08/2019 16:23:58,12/08/...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Alex_Rajkov ,

According to error message, It seems like you have inputted wrong datetime parameter.
Current power bi not recognize datetime values who greater than 12/31/9999 or less than 1/1/1753. Please use valid datetime value to instead current one.

Regards,

Xiaoxin Sheng

  • Alex_Rajkov's avatar
    Alex_Rajkov
    Advocate III
    7 years ago

    Hi Xiaoxing,

     

    according to your response you didn't read my post.

    You simply stated the error message.... :(

     

    KR
    Alex

    Anonymous wrote:

    Hi Alex_Rajkov ,

    According to error message, It seems like you have inputted wrong datetime parameter.
    Current power bi not recognize datetime values who greater than 12/31/9999 or less than 1/1/1753. Please use valid datetime value to instead current one.

    Regards,

    Xiaoxin Sheng