Forum Discussion
Helper IConnect PBI to AS400 or BO
Hi G_CR_23
You can use warehouse in PowerBI to connect the AS400, you can refer to the following link.
How to connect IBM DB2 for iSeries (AS/400) to Microsoft Power BI (datavirtuality.com)
And you can refer to the following link to know about the IBM Db2 connector.
Power Query IBM Db2 database connector - Power Query | Microsoft Learn
And if you use the datasource by the connector, you need to configure a gateway. you can refer to the following link to refer to the configuration.
Solved: Configuring Power BI gateway connection : AS400 an... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi G_CR_23
You can use warehouse in PowerBI to connect the AS400, you can refer to the following link.
How to connect IBM DB2 for iSeries (AS/400) to Microsoft Power BI (datavirtuality.com)
And you can refer to the following link to know about the IBM Db2 connector.
Power Query IBM Db2 database connector - Power Query | Microsoft Learn
And if you use the datasource by the connector, you need to configure a gateway. you can refer to the following link to refer to the configuration.
Solved: Configuring Power BI gateway connection : AS400 an... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.