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

[Anonymous]

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?

[Anonymous]

Hi @Anonymous ,

In the advanced editor in Power Query, the M language we use, the language you feed back to @Daryl-Lynch-Bzy  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]

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

[Anonymous]

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.

[Daryl-Lynch-Bzy]

Hi @Anonymous - can you provide more details about the Power Query.  Could you insert the Advanced Editor text (without sensitive details)?

[Anonymous]

Select T1.RUNID, T1.RUN_DATE, T2.BMT_NAME, T3."MRK_LNG", T3."MRK", T4.RESULT, T5."MATERIAL", T1.RUN_STATE, T4."READING",T3."USL", T3."LSL"

FROM "DB"."RUN" T1, "DB"."BMN" T2, "DB"."MRK" T3, "DB"."MED2" T4,"DB"."MAT" T5, "DB"."TESTRUNS" T6

WHERE T1.BMT_ID (+)= T2.BMT_ID
AND T1.DATE_ID (+)= T3.DATE_ID
AND T3."NUM" (+)= T4."NUM"
AND T1.PRT (+)= T4.PRT
AND T1.SID (+)= T5.SID
AND T1.RUN_DATE (+)= T6."RUN_DATE"
AND T4."KEY" (+)= T6."KEY"

AND T1.RUN_STATE in ('F','P')
AND T5."MATERIAL" in ('xx')

AND T2."BMT_NAME" in ('STM-T3070-52','STM-T3070-11')

AND T1."RUN_DATE" >= sysdate-2
AND T1."RUN_DATE" <= sysdate

[Anonymous]

@Daryl-Lynch-Bzy  I have changed the table names as it had sensitive information. I hope this helps you understand. The query runs just fine in SQL but when I try to integrate that in PowerBI it shows the above error