Unable to connect PowerBI gateway with IBM AS400C series DB2 DB using read only account access.

[itwant_singh]

We are trying to connect IBM AS400C series database from powerBI gateway.

The data base account used is having read only access and we are unable to connect to IBM AS400C series DB2 DB.

We would like to know following as IBM PMR team is requesting us the info:

• PowerBI gateway Driver data source is configured for read-only or read/write access.
• What type of driver(odbc or Jdbc) is using for DB2 connection in power BI

Please feel free to request more details if needed and kindly treat the request as high priority.

[v-qiuyu-msft]

Hi @itwant_singh, 

Please create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu