SQL upload via ODBC

[DeanM]

I am unable to upload data from SQL.  This used to work but crashed.  My SQL view has been working for 2 years but won't let me update any new or existing files

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Invalid date/time: . '.

[Anonymous]

Hi @DeanM,

What version of power bi desktop are you test? Did these connection works when you work with previous versions? Please share mode detailed information to help us clarify your scenario:

How to Get Your Question Answered Quickly 

BTW, did these views work well when you use the default power bi SQL connector? If that is a case, I'd like to suggest you check your odbc driver and data providers if they were not compatible with your SQL views.
Regards,

Xiaoxin Sheng

[Greg_Deckler]

@DeanM - Sounds like maybe some data got introduced into your view that is not a valid date/time?