Configuring Power BI gateway connection : AS400 and ODBC

[swapnil]

Hi Team,

I have recevie one request for configuring Power BI gateway for AS400 database. Please help me here to configure. I have tried it with different options but no chnace.

I got below information from Devlopment team.

Odbc.Query("Driver={Client Access ODBC Driver (32-bit)};System=XXXXX;DBQ=XXXXX;")

Thanks,
Swapnil

[v-shex-msft · Accepted solution]

Hi @swapnil,

Perhaps you can take a look at below link about as400 connect string.

AS/400 connection strings

Regards,

Xiaoxin Sheng

[swapnil]

HI Xiaoxin,

Thanks for your help . This worked for me.

Thanks,

Swapnil