Forum Discussion

dyee4613v1's avatar
dyee4613v1
Frequent Visitor
1 year ago
Solved

Cannot Connect to AS400 with Power BI

Hi.  I'm trying to connect to AS400 database using an ODBC driver.  I tried this with both the ODBC driver and the IBM DB2 Database Drivers with little success.    The ODBC Driver does connect but ...
Need Help
  • VahidDM's avatar
    VahidDM
    1 year ago

    Hi dyee4613v1 

     

    Ensure your connection string and DSN are set up to use the correct default schema (library). In your ODBC settings, add the parameter DefaultLibrary (or similar, depending on your driver version) so that your login defaults to the library containing your tables. Also, verify that you’re using the latest ISeries Access ODBC driver (or IBM i Access Client Solutions ODBC driver) and that your credentials have permissions for the target tables. If necessary, use Power Query’s Advanced Editor to further refine the connection string.

     

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

    Appreciate your Kudos!! 

     

    LinkedIn|Twitter|Blog |YouTube 

v-kathullac's avatar
v-kathullac
Icon for Community Support rankCommunity Support
1 year ago

Hi dyee4613v1 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya