Forum Discussion

saagarkinja's avatar
saagarkinja
Advocate II
10 years ago

SAP BW connectivity issue

Dear All,   I am trying to integrate and fetch data from SAP BW using Power BI SAP BW direct connector.   However,after some time it pops up below error message, ------------- DataSource.Error:...
Tips and Tricks
saagarkinja's avatar
saagarkinja
Advocate II
10 years ago

Hi Tristan,

Thanks for your response.

 

I am getting below error while connecting to SAP BIW,

 

 

 

"Details: "Access to SAP Business Warehouse requires SAP client tools to be installed, including the latest version of SAP Netweaver RFC. See here for more information: https://aka.ms/kgu6rn""

 

I already downloaded SAP GUI 7.3 with latest patch available. As per SAP Basis team, it is already part of SAP GUI. So, no help.

 

Request your suggestion.

 

Thanks,
Saagar Kinja

tristanstcyr's avatar
tristanstcyr
Helper I
10 years ago

Hi,

 

Can you make sure that the processor is the same for both installations (32-bit vs 64-bit)? If the architectures don't match, you might be able to find a standalone installer of the Netweaver RFC.

 

Thanks,

Tristan

  • saagarkinja's avatar
    saagarkinja
    Advocate II
    10 years ago

    Thanks for your response.

     

    I tried using the 64 bit file and now able to connect to SAP BIW.

     

    This issue remains same, when I increase the period to more than 6 months it returns same error. Already tried filter's and other conditions.

     

    Still no success. Frown is shared.

     

    Please share if you have any suggestions.

     

    Thanks,
    Saagar Kinja

     

     

    • tristanstcyr's avatar
      tristanstcyr
      Helper I
      10 years ago

      Aside from adding filters before adding more columns, I don't have a suggestion. Is this a query that you're usually able to fulfill with other tools? If so, can you tell us which ones? Can you check to make sure that the query returns the results in the same way?

      • saagarkinja's avatar
        saagarkinja
        Advocate II
        10 years ago

        Yes. I tried using SAP Lumira. It shows complete hierarchy structure of Customer information.

        Appreciate your help on this.

         

        Thanks,

        Saagar Kinja

    • psakharshete's avatar
      psakharshete
      Advocate I
      10 years ago

      Hi Sagar,

       

      Could you please provide what exactly you did to resolve this error?

       

      I am also getting this error:

      "Access to SAP Business Warehouse requires SAP client tools to be installed, including the latest version of SAP Netweaver RFC.  See here for more information: https://aka.ms/kgu6rn"

       

      I have copied librfc32.dll in C:\Windows\System32 folder. I'm on Windows 7.

       

      Appreciate your input.

       

      Regards,

      Prasad

       

       

    • psakharshete's avatar
      psakharshete
      Advocate I
      10 years ago

      Hi Sagar,

       

      "Access to SAP Business Warehouse requires SAP client tools to be installed, including the latest version of SAP Netweaver RFC. See here for more information: https://aka.ms/kgu6rn"

       

      I am getting the same error. Could you provide details of how you resolved this error?

       

      I have copied librfc32.dll in C:\Windows\System32 folder in Windows 7.

       

      Regards,

      Prasad

       

      • saagarkinja's avatar
        saagarkinja
        Advocate II
        9 years ago

        Dear Psakharshete,


        The "Netweaver RFC Library Files" are available on SAP Support Portal. It can be easily downloaded and extracted.


        Please note below points,


        1-SAP GUI 64-bit is as normally not available. If yes in your organization, you install it and test it the issues will be resolved.

        or,

        2-Please install 32-bit SAP GUI and download and extract 64 bit Netweaver RFC file to system 32 folder. The issue will resolved.

        or,

        you send me en email. I will share the .zip file with you.


        Thanks,

        Saagar Kinja

        [email protected]