Forum Discussion
Gateway SAP BW
- Anonymous9 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
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,
Hi MrJannieSA,
where can i find those libraries?
Thanks