powerBI Desktop - error returned when loading data from ODBC 'Failed to save modifications to server

[cheriemilk]

hi team,

I can load data to powerBI Desktop by csv file successfully. 

But when I load it  by ODBC in powerBI desktop, I got below error and the data can be loaded successfully. Is there are any expert can help advice?

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [22018] [MySQL][ODBC 1.4(a) Driver][mysqld-5.7.12 mongosqld v2.14.4]. '.

Here is the screenshot with error.

[cheriemilk · Accepted solution]

I figure out the root cause of this error, and got a solution.

Root cause: in one of the column, I have non-English character values.

solution: create a DSN with unicode, instead of ASNI.

[ribisht17]

@cheriemilk '

Similar thread here Solved: Failed to save modifications to the server. Error ... - Microsoft Power BI Community

Regards,

Ritesh

[cheriemilk]

@ribisht17 , thanks fr the advice. I have tried the solution you linked above by changing the timestamp to 'date' type. But it does't resolve my issue. the same error still occurs when I loading data via ODBC in powerBI Desktop.

Thanks,

cherie