Forum Discussion
Power Query Online + SAP BW Application Server: Exception Error
Hi Everyone,
For starter, in order to establish a successfull connection between Power BI Desktop and SAP BW Application Server as the data source, I have installed SAP .Net Connector 3.0 for .NET 4.0 on x64 in my laptop, which I believe that the SAP Connector is Version 3.0.25. The connection is successful and I could access the data from SAP server on Power BI Desktop.
Now, I tried to do the same using Power BI Services/Website to connect to SAP BW Application Server as the data source, but this time I also installed and configured the On-premises Data Gateway at the SAP server as stated in Power Query SAP Business Warehouse Application Server connector - Power Query | Microsoft Learn.
The On-Premises Data Gateway has been installed and configured successfully as shown below:
But, when I tried to connect to the data source (SAP BW Application Server) using the On-Premises Data Gateway via Power BI Services/Website, I got the following error:
"An exception occurred: This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'SAP .NET Connector 3.0.0.42': https://go.microsoft.com/fwlink/?linkid=872300".
Are there any other configurations or installations that need to be done? As I have checked that SAP Connector had already been installed in my laptop:
Or do I have to install exactly SAP .NET Connector 3.0.0.42 to resolve the error?
Your assistance and advice is very much appreciated. slorin AlienSx BA_Pete collinsg ronrsnfld
Thank you and Best Regards,
Yacheou
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.
7 Replies
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
