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 - can you provide more details about the Power Query.  Could you insert the Advanced Editor text (without sensitive details)?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Anonymous  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