Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
alongi
Frequent Visitor

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

 

 

1 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



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

4 REPLIES 4
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
alongi
Frequent Visitor

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

 

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



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
alongi
Frequent Visitor

understood thanks

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.