SQL upload via ODBC

DeanM · ‎09-08-2020

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 · ‎09-10-2020

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 · ‎09-08-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...