Forum Discussion
Cannot Connect to AS400 with Power BI
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!!
Super UserHi 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!!