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 convert the value null to type Text..
An unexpected exception occurred.
I have checked all columns for errors/nulls and see this in every column

I have gone through each column and removed replaced null values with blank and continue to get the error message when I close and apply.

I have built out this type of report every week and this is the first time it has happened. 

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.

2 Replies

  • 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.