Forum Discussion
Power Query Online + SAP BW Application Server: Exception Error
Thank you very much BA_Pete ! Finally managed to establish connection between Power BI Services and SAP BW Application Server.
What-to-do:
1. Install and configure Power BI Data Gateway in the SAP server environment.
Power BI Data Gateway: Install an on-premises data gateway | Microsoft Learn
1.a) Make sure you have the access to the Power BI Data Gateway in your Power BI Services.
Source: Add or remove a gateway data source - Power BI | Microsoft Learn
2. Install SAP .NET Connector in the SAP server environment (Currently using SAP .Net Connector 3.0.25)
SAP Installer: https://support.sap.com/en/product/connectors/msnet.html?anchorId=section
3. Create a Workspace in Power BI Services > Create New Dataflow > Choose SAP BW Application Server
4. Enter the required credentials
5. And it's done.
I appreciate your guidance and support very much BA_Pete ! Thank you again.
Hi Yacheou,
Assuming you're using separate machines for your gateway(s), you will need to install the SAP Provider on every on-prem gateway machine as well.
If you're trying to use your laptop as a gateway, then I'd recommend changing this setup to having separate, always-on, machines instead. As soon as you switch your laptop off, nothing will refresh in the Service.
Pete
I see, so currently my administrator has installed the On-Premises Data Gateway in another machine (let's called it Machine A) which act as the SAP server. So, does that mean I have to install SAP .NET Connector to my laptop and ask my administrator to install SAP .NET Connector on Machine A as well?
Yes. Any and all connection providers need to be installed on every gateway machine that the PBI Service can potentially use to connect to your source. Whether the PBI Service can potentially use a particular gateway to connect to a particular source will depend on how you set up/structure your gateways (distinct task/role-based, clustered etc.).
Pete
Understood, I will ask my administrator to install SAP .NET Connector on the server as well, and get back on the results. Thank you for your prompt response BA_Pete!