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 

dyee4613v1's avatar
dyee4613v1
Frequent Visitor
1 year ago

Hi.  I realized I never responded to this.  The issue was the library schema.  We thought you could just do it like with SQL where you do select * or something like that.  It didn't work.  You had to point to a specific library.  We tried a specific library and then suddenly we had access to everything.