Forum Discussion
IBM DB2 through Power BI gateway
Hello,
When I create a repport with IBM DB2 database with PBI Desktop, i have choice between IBM or Microsoft Driver.
For some problem with DB, i prefered use the IBM one.
But, when I create the datasource on PBI portal i doesn't find this choice anymore.
Is there only one single driver avaible ? IBM or Microsoft ?
So, what prerequisit i have to install on my gateway server ?
Do I need IBM DB2 DS Driver ? or some Microsoft Prerequisit ?
What is the connect string format in "Server" and "Database" field when creating DataSource on portal ?
Thanks for all of this,
Alexander.
Hi Anonymous,
If you don't have a database driver, you will use Microsoft Driver in desktop. Then you publish it to service, it still use the Microsoft Driver when you refresh data in Power BI service. For your error message, I suggest you create a support ticket in the right bottom here to get dedicated support.
Best Regards,
Angelia
6 Replies
v-huizhn-msftMicrosoft Employee
Hi Anonymous,
>>So, what prerequisit i have to install on my gateway server? Do I need IBM DB2 DS Driver ? or some Microsoft Prerequisit ?
In Power BI desktop, you get data from IBM DB2. When you choose IBM driver, please ensure that you have IBM DB2 Data Server Driver installed on your computer (minimum requirement is the IBM Data Server Driver Package (DS Driver)). Minimum provider version is 10.1, Minimum data source version is 9.x+, please check data source Prerequisites here. If you choose Microsoft Driver, the DB2 Server Driver is not necessary.
>>But, when I create the datasource on PBI portal i doesn't find this choice anymore. Is there only one single driver avaible ? IBM or Microsoft ?
When you publish the report created from DB2 to service, if you want to refresh data in service, you have to configure gateway. And you add datasource under your gateway. You just type the credentials of your database. Type the server name, database name, username and password. The progress of adding datasource doesn't need a database driver.
>>What is the connect string format in "Server" and "Database" field when creating DataSource on portal ?
It means, you add datasource in gateway, right? If it is, just use the right Server name and Database in the following highlighted in red line box, which likes in Power BI desktop.
Best Regards,
AngeliaThanks for this quick reply.
About the gateway and this point :
"When you publish the report created from DB2 to service, if you want to refresh data in service, you have to configure gateway. And you add datasource under your gateway. You just type the credentials of your database. Type the server name, database name, username and password. The progress of adding datasource doesn't need a database driver."
For refresh on service, If I doesn't need a database driver, is that because Datasource in gateway use the Microsoft driver ?
- v-huizhn-msft
Hi Anonymous,
If you don't have a database driver, you will use Microsoft Driver in desktop. Then you publish it to service, it still use the Microsoft Driver when you refresh data in Power BI service. For your error message, I suggest you create a support ticket in the right bottom here to get dedicated support.
Best Regards,
Angelia