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
manisharora's avatar
manisharora
Regular Visitor
10 years ago

Hi Team,

 

I am facing the same issue while extracting fields from Cube(Object).

Connection with BW System has been done. But not able to fetch/extract data from BW system.

 

PFB the error:-

 DataSource.Error: SAP Business Warehouse:

Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV' Details: DataSourceKind=SapBusinessWarehouse DataSourcePath=10.40.1.41/00/100

ErrorCode=-2147467259

 

 Please help me to correct this.

 

Thanks

Manish Arora

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