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

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 ?

 

 

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: ..