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 All,

 

Thanks for your response.

 

Please note,

1- As SAP BW is Primary DW for Org., SAP Basis team doesn't want to manipulate Default Table size. 

2- I tried minimizing the size of my query, still same issue. So, we shared a Frown to Power BI Desktop Support Team. The issue is under process.

 

I think, SAP BIW connector should not be used and referred when planned to connect for Stable Solution.

Let us wait for genral availability of preview connector.

 

Thanks,

Saagar Kinja

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

  • Maring's avatar
    Maring
    New Member
    9 years ago

    Hi,

    is this has been solved? 

    I have the same issue and the only thing that helped is to filter the periods of data... which if funny, because it is not enough and SAP BW is running it with no problem.

    Why does the PBI cannot load this data size? 

    Thanks

    Marina

    • eikden's avatar
      eikden
      Frequent Visitor
      9 years ago

      I have the same issue faced. Anyone already find out the solution to resolve this?

  • lizaramlee's avatar
    lizaramlee
    Frequent Visitor
    9 years ago

    hi Manish,

    i am now facing same issue..

    may i know how u handle to solve it?