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 be able to proceed:

1. How does Power BI establish a secure connection with an intranet?

2. Is Gateway independently installed in a server inside the DMZ so that it can serve as a bridge between Power BI and SAP BW?

3. Is necesary install the RFC of SAP in the server tha we will install the Gateway? Or, What should we install on the server where we will install the gateway for the gateway establishes the connection to the data base SAP BW?
4. Wich kind of permissions must have the user of the conection on gateway configuration?

Thanks a lot!

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

13 Replies

  • 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

    • GabiSanchez's avatar
      GabiSanchez
      Regular Visitor
      3 years ago

      Hi Lydia, we were not able to connect to the data sources in SAP whitout the Connector that is used for Desktop connection. Please could you confirm whether this connectors are or are not necesary for the standard gateway implementation ir order to connect to the data sources on premise from Power Bi Service? thank you.

  • MrJannieSA's avatar
    MrJannieSA
    New Member
    9 years ago

    Hi JoPalacio,

     

    Although a solution was published, I have an alternative option that worked for me as I did not want to install the full SAP NetWeaver RFC

     

    I copied the followings files from the SAP Folder into my "C:\Program Files\On-premises data gateway" & restarted the server, gateway now creates data sources from the cloud like a charm.

     

    icudt34.dll
    icuin34.dll
    icuuc34.dll
    libicudecnumber.dll
    libsapucum.dll
    libsapucum.lib
    sapdecfICUlib.lib
    sapnwrfc.dll
    sapnwrfc.lib

     

    This also works for Power BI Desktop, copy these files into "C:\Program Files\Microsoft Power BI Desktop\bin"

     

    Hope this can help someone out.

     

    Cheers,

    • pasmar555's avatar
      pasmar555
      Advocate I
      8 years ago

      Hi MrJannieSA,

       

      where can i find those libraries?

       

      Thanks

    • pasmar555's avatar
      pasmar555
      Advocate I
      8 years ago

      Hi mrJannieSa,

       

      where did you get those libraries?

       

      Thanks