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.
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!
BA_Pete Currently, SAP .NET Connector Version 3.0.25 has been installed both on my laptop and on the server/gateway machine. But, I face the same error when I tried to connect to SAP BW Application Server with Power BI Services/Website. May I ask if there is any additional configurations needed? As I have configured both laptop and gateway machine according to Power BI documentation as shown here: Power Query SAP Business Warehouse Application Server connector - Power Query | Microsoft Learn.
This is a huge question, and likely impossible for me to give a direct answer to. Without being able to see exactly what you're seeing, it's really hard to understand what might be causing you these issues to be honest. A lot will depend on your local tech/infrastructure, so you may need to check things like:
-1- Which provider version does your SAP App Server require? Does it always demand the latest version, or do you have to match the provider version to the DB version?
-2- Do you need to run your exernal connections through a proxy server to get through the firewall? If so, you may need to update the proxy values in the following gateway config files:
--- EnterpriseGatewayConfigurator.exe
--- Microsoft.Mashup.Container.NetFX45.exe
--- Microsoft.PowerBI.EnterpriseGateway.exe
-3- Have you correctly added your App Server as a new source on the gateway(s) in the PBI Service? Have you then updated the dataset of any report using this source with the gateway source?
Sorry I can't be of more help here. I myself have always found gateways the most fiddly and frustrating part of setting up any PBI infrastructure, especially when dealing with external Drivers/Providers. I still have nightmares about an old Oracle server I had to connect to where it turned out the provider would only run on Windows 7, so I had to set up a Win7 gateway just for that source! Brrrrrr 😖
Pete