Forum Discussion

alongi's avatar
alongi
Frequent Visitor
4 years ago
Solved

DB2 ODBC Connection - Report refresh

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

 

 

Need Help

4 Replies

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    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's avatar
      alongi
      Frequent Visitor
      4 years ago

      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