Forum Discussion

Ksven's avatar
Ksven
Icon for Advocate III rankAdvocate III
5 years ago

SAP BW Connection | On-Premise Gateway | undefined Error

Hi lovely community,   unfortunately I can't get SAP BW connection with On-Premise Gateway:     On-Premise: Standardmodus SAP BW Installations on VM:  SAP .NET Connector 3.0 installed (SA...
Need Help
Ksven's avatar
Ksven
Icon for Advocate III rankAdvocate III
5 years ago

Hi v-robertq-msft ,

 

thank you for reply!

 

Before I got your message we started to test the SAP BW connection on virtual machine via Power BI Desktop to ensure its not a Gateway problem. Here we received the following error:

 

After this I've researched for this error message and have found the follwing way:

https://community.powerbi.com/t5/Report-Server/SAP-BW-Message-server-connection-failed/td-p/643514

 

We have done added alle necessary tcp entries and tried again the SAP Connection via Gateway on Power BI service. Now it works fine with Power BI:

 

 

But we have tried the same with Power Apps Dataflows with the same Gateway and got the following message (we have ensured the right credentials):

 

Do you think this is still cause of SAP NetWeaver library?

We already have installed SAP.NET Connector 3.0 like described here:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-bw-connector

 

I guess we don't need the library?

"The first version of SAP BW implementation required NetWeaver DLLs. If you're using Implementation 2.0 of the SAP Connector, and not using the first version, the NetWeaver DLLs are not required."

 

Do you have an idea why SAP BW connection works with Power BI Service but not with Power Apps Dataflows?

 

BR,

Sven

  • Ksven's avatar
    Ksven
    Icon for Advocate III rankAdvocate III
    5 years ago

    Hi v-robertq-msft ,

     

    thank you for reply.

    I'm already very familiar with Power Apps Dataflows especially with integration in Microsoft Dataverse. For now I've jsut some trouble with the SAP connection.

     

    But general requirements for SAP Connection via Gateway are the following:

    -> VM with US region settings

    -> Installation of SAP .NET Connector 3.0

    -> VM has internal VPN Network

    -> SAP NetWeaver RFC not necessary cause its included in SAP .NET Connector 3.0 ?

     

    If its like this, we have already set up right and would open a new support ticket..

     

    BR,

    Sven

    • v-robertq-msft's avatar
      v-robertq-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, Ksven 

      Under this circustance, opening a support ticket can be a good solution to get the further help. You can also go back to share some experience if the Microsoft support team helped you to find the root reason.

      Thank you very much!

       

      Best Regards,

      Community Support Team _Robert Qin

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.