Forum Discussion
SQL upload via ODBC
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: . '.
2 Replies
DeanM - Sounds like maybe some data got introduced into your view that is not a valid date/time?
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
