RE: Power BI connecting to an AS/400

You'll need the "Windows Application Package for Windows operating systems" (see https://www.ibm.com/support/pages/ibm-i-access-client-solutions).

After that's installed, you'll need a connection. Launch "ODBC Administration" (on Win7, press the Windows key and type "ODBC"). On the User DSN tab click Add. Pick the "IBM I Access ODBC Driver" and fill in all the details. Within PowerBI, I think you'll find this new connection under something like "Other data sources".


HTH



-----Original Message-----
From: Alan Shore via MIDRANGE-L [mailto:midrange-l@xxxxxxxxxxxxxxxxxx]
Sent: Monday, December 09, 2019 12:17 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Alan Shore <ashore@xxxxxxxx>
Subject: RE: Power BI connecting to an AS/400

Thanks for the reply Justin, but KI have no idea as to what needs to happen Any documentation anywhere?

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill