Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

Hello all, I am getting this error when I try to run my query into PowerBI. Can anyone help me with understanding why this is happening and how do I correct it?  
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

In the advanced editor in Power Query, the M language we use, the language you feed back to Anonymous  looks like an SQL statement.

We can enter the sql statement when we connect to the database in power bi desktop.

 

Import data from a database using native database query - Power Query | Microsoft Docs

 

 

Best Regards,

Stephen Tao

 

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
4 years ago

Anonymous That is exactly what I am doing. I am writing my SQL query when I am connecting to the DB itself.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I found the following for the cause and solution of the error, please refer to:

    Cause: Attempt to convert a negative number to an unsigned integer.
    Action: Use the sign flag ORLTSB to convert a signed number.

     

    Reference:Oracle 12cR1 OCI-22063 reading negative value [string] as unsigned

     

    Best Regards,

    Stephen Tao

     

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