AS400 Multi-Member Files

[brianleewilliam]

I am able to connect to AS/400 using ODBC.  My issue is that I can only access the first member of a multi-member file.  I can see all the records of the first member, but other members have thousands of records.  How do I connect to those other members?

[Anonymous]

@brianleewilliam,

I am not clear about the members you mentioned, do you mean table? And do you use ODBC entry in Power BI Desktop to connect to the data source? If so, do you get data from other tables when writing SQL statement?



Regards,
Lydia

[brianleewilliam]

The problem I'm having is that our AS400 is a multi-member file and I can only gain access with ODBC to the first member.  In the snip below, only the records for M001 show up.  I cannot gain access to the M100 records.  When I try the IBM DB2 database connector, I get the error shown in the second snip. 

[Anonymous]

@brianleewilliam,

Are you able to get full records when connecting to ODBC data source in Excel? And for the above error message, please follow the guide in the similar thread below to troubleshoot it.

https://community.powerbi.com/t5/Integrations-with-Files-and/Cannot-connect-to-AS400-via-IBM-DB2-dat...

Regards,
Lydia