Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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,
Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks 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's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI v-huizhn-msft,

      Just to be sure...

      If i was using the IBM driver through Power BI Desktop, and then publish this repport, when I created the DataSource in Gateway : is the IBM Drivers still avaible.

      There is something to change when create the DataSource ? I don't find any option.

      How does it detect that dateset using Microsoft or IBM driver ?

       

      Thanks for precision.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI v-huizhn-msft

    For information, my server connection is something like : "mysrv.prod.domaine.fr:portnumber".

    Connexion with this is OK from Desktop, and NAT/firewall are fully configured.

     

    But from DataSource online, i have this error message :

     

    ID d'activité: 71963a9c-ee39-49a4-a898-d1d6cd93b784 
ID de demande: 2c6b5d37-fa6e-d5fc-381b-71a44a4b6ef4 
URI du cluster: https://wabi-europe-north-b-redirect.analysis.windows.net 
Code d'état: 400 
Code d'erreur: DMTS_PublishDatasourceToClusterErrorCode 
Heure: Fri Dec 08 2017 11:04:41 GMT+0100 (Paris, Madrid) 
Version: 13.0.3235.216 

: {"Gtw_PRD":{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft Db2 Client: The connect timeout period expired before the DRDA server responded to the DRDA client connection request. SQLSTATE=HYT01 SQLCODE=-7049"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"DB2"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"mysrv.prod.domaine.fr:portnumber;DBName"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"0"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"The connect timeout period expired before the DRDA server responded to the DRDA client connection request. SQLSTATE=HYT01 SQLCODE=-7049"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}} 
Gtw_PRD: Received error payload from gateway service with ID 338883: Mashup expression evaluation error. Reason: ..