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/2019 16:24:28,Fehler,Error: An internal error occurred... RootActivityId = 415c20ec-6fd7-40e6-b6e3-0f8521044913.Param1 = SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Request ID: 95a6922e-4408-56f7-17ec-82af235cc283.
No changes being made in the simple PQ script. Its just get the columns and define the column datatype.
Already checked the MS NAV database system time. Everything is just fine there.
The dataflow worked just fine til last week.
In the dataflow options I (had to) change the region from Germany to English (United States). But tested reversing back to Germany also. No success.
The same refresh works just fine via PBI Desktop..
Help needed.
