Enterprise Gateway - Import Refresh Data Connection

[Anonymous]

I am trying to understand more about the enterprise gateway with the intent of setting up refresh schedules for imported datasets published to the Power BI Service.

My dataset creates and queries via import mode a DB2 connection. The dataset was then published to a Premium capacity workspace. Our enterprise gateway is installed on an on-premises gateway server (VM is used). 

When I tried to refresh my dataset, I was getting an error as follows:

 We were unable to find a database provider with invariant name 'IBM.Data.DB2'. This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'IBM Data Server Driver Package (DS Driver)': https://go.microsoft.com/fwlink/p/?LinkID=274911

Am I correct in understanding that the DB2 Drivers need to be installed on the Server that houses the Enterprise Gateway to handle the data source connections?

[Seth_C_Bauer · Accepted solution]

@Anonymous That is the likely course of action. The gateway server is the machine that has to access DB2, then communication from that server to the Power BI Service is also from that server for refresh.

So you went from your local machine during development where you likely have all the drivers need to work with the data, but now that you have published to the Service, the gateway server is handling the refresh and needs access and likely drivers to support the report refreshes.