Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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.

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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