Forum Discussion

MBWATSON's avatar
MBWATSON
Helper II
2 years ago
Solved

Getting Error Message Failed to save modifications to the server. Error returned: 'OLE DB or ODBC

Hi there, Using Power Query to transform data in Power BI and I get this message: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] We cannot con...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MBWATSON ,

     

    The reason for this type is that power query, when trying to apply changed type, tries to get the value supplied in the cell and converts it to the specified type based on the format defined for that data type in the local user's windows regional settings. If it fails to do so, you will receive an Unable to convert error.

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MBWATSON ,

 

The reason for this type is that power query, when trying to apply changed type, tries to get the value supplied in the cell and converts it to the specified type based on the format defined for that data type in the local user's windows regional settings. If it fails to do so, you will receive an Unable to convert error.

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.