Forum Discussion
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?
6 Replies
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
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.
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.