DB2 ODBC Connection - Report refresh

[alongi]

We have an on-prem DB2 database that we are connecting to via an ODBC connection. We were able to publish reports but noticed we can't schedule refreshed in the Power BI Service. Am i missing something, is this not possible?

I believe the ODBC connection to DB2 basically in an import.

Thanks

[edhans]

You will need to set up an On Prem Gateway. On-premises data gateway - Power BI | Microsoft Docs

It will allow you the service to contact the Gateway, and the Gateway will connect to your DB2 database. You will need the ODBC driver installed on the gateway machine.

The Gateway is free. It is all included in your Pro license you use to publish. Just need a high end PC or server to run it on, but it should not be a domain controller or the server your database is on for performance and security reasons. A Windows 10/11 client will work. Doesn't have to be  a server.

[alongi]

Thanks, we use the Gateway with other sources such as SQL Server. we have a system dsn for DB2. I wasnt sure if the on-prem gateway supports DB2, sounds like you are saying it definitely does?

Please confirm

Thanks

[edhans · Accepted solution]

No, I am not definitely saying it is supported, but ODBC datasources are supported, so unless there is something off with the DB2 ODBC driver, it should be supported. Power BI data sources - Power BI | Microsoft Docs

[alongi]

understood thanks