Forum Discussion

rguerrero1's avatar
rguerrero1
New Member
9 years ago

Apply Changes ODBC ERROR

 

Hello,

 

I am getting data from AS400 server. I already connected using Client Access ODBC Driver 32-bit , everything looks good in the query section. 

 

when i click on apply the next error appears:

 

 

can you help me out?

 

thanks

 

Need Help

3 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi rguerrero1,

    If you do anything in Query Editor Navigator? And you can upload the data from AS400 server to Excel successfully?

    Best Regards,
    Angelia

    • rguerrero1's avatar
      rguerrero1
      New Member
      9 years ago

      Yes,

       

      I can upload data from AS400 to microsoft excel.  i have the same file upload to excel and there is no error.

       

      regards

       

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi rguerrero1,

        What's your Power Query statement, if you check you did wrong operation in Query Editor?

        Thanks,
        Angelia