Forum Discussion

JoPalacio's avatar
JoPalacio
New Member
9 years ago
Solved

Gateway SAP BW

Hi All I need your help.... We have been reviewing the Gateway subject with architecture and we have two questions that we need to make sure are clear so we can understand the complete concept and ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

     

    Hi JoPalacio,

    Firstly, for more details about Power BI security, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/ .

    Secondly, yes, Power BI gateway acts as a bridge, providing quick and secure data transfer between Power BI and SAP BW. And gateway should be installed on a computer that can be left running all the time and is connected to the Internet. For more details about requirements of installing Power BI gateway, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/ .

    Thirdly, you don’t need to install RFC of SAP in the server that install gateway. Assume that you install and register on-premises gateway, you would need to sign in Power BI Service and add SAP data source under the registered gateway. There is an example for your reference, in the following screenshot, after you enter server name, system number and so on, it will establish the connection to SAP BW.


    At last, for your fourth question, if you mean that let other users add data sources under registered on-premises gateway, you would  need to add users on the Administrators tab for the gateway, this way, users can administer the gateway.  For more details, please review this article.




    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

 

Hi JoPalacio,

Firstly, for more details about Power BI security, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/ .

Secondly, yes, Power BI gateway acts as a bridge, providing quick and secure data transfer between Power BI and SAP BW. And gateway should be installed on a computer that can be left running all the time and is connected to the Internet. For more details about requirements of installing Power BI gateway, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/ .

Thirdly, you don’t need to install RFC of SAP in the server that install gateway. Assume that you install and register on-premises gateway, you would need to sign in Power BI Service and add SAP data source under the registered gateway. There is an example for your reference, in the following screenshot, after you enter server name, system number and so on, it will establish the connection to SAP BW.


At last, for your fourth question, if you mean that let other users add data sources under registered on-premises gateway, you would  need to add users on the Administrators tab for the gateway, this way, users can administer the gateway.  For more details, please review this article.




Thanks,
Lydia Zhang

DougP's avatar
DougP
Frequent Visitor
9 years ago

Hi Anonymous JoPalacio

 

I think you do need to install the SAP Netweaver RFC on the server - this caused an issue when trying to set up a Data Source in the gateway explicity stating that SAP client tools needed to be installed.

 

 

Installing the relevant files resolved this issue.

 

Thanks,

Doug

  • JoPalacio's avatar
    JoPalacio
    New Member
    9 years ago

    Thanks a lot!

    Solved! :)

    • Mond's avatar
      Mond
      Helper III
      9 years ago

      Hi,

       

      Is it a personal or enterprise gateway.

    • lizaramlee's avatar
      lizaramlee
      Frequent Visitor
      8 years ago

      HI Jo,

      can u share what need to be done on basis site? any new sm59 entry need to be created?

      do we need to activate the snc?.

       

      Thanx.

      xoxo

  • Mond's avatar
    Mond
    Helper III
    9 years ago

    Hi Doug,

     

    I received the same kind of error when trying to create new datasource in the enterprise gateway as an admin with SAP HANA (Data source type):

     

    Error Code: DM_GWPipleline_Gateway_DataSourceAccessError

    Underlying error code: -2147467259
    [SAP AG][LIBODBCHDB DLL][HDBODBC]
    Underlying error message: Communication link failure;- 10709
    Connect failed (no reachable host left)

     

    Do you have any idea for this kind of error code.

     

    Thank you

  • snaik's avatar
    snaik
    Frequent Visitor
    4 years ago

    Hi Doug,

    We are also getting the same error when trying to register the SAP BW data source on the PowerBI gateway.  Can you please tell me which server you have installed the RFC? Our BW is has it all. My desktop I have a BW connector installed and I am able to connect SAP BW from my PowerBI Desktop. However, I cannot connect SAP BW from the PowerBI service.  This is the first time we are trying to establish a connection between SAP BW and PowerBI, we are not able to figure out where is the problem and what is missing where. The error does not exactly specify or I am not able to understand.  

     

    Thank you for your help. 

    Shailaja 

  • MindaugasM's avatar
    MindaugasM
    New Member
    3 years ago

    Could you please clarify which librabries and were did you installed?