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
tristanstcyr's avatar
tristanstcyr
Helper I
10 years ago

Hi,

 

Can you try with the latest Power BI Desktop release and see if the issue still reproduces?

 

Thanks!

Tristan St-Cyr

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?