Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

SAP BW timeout option, runtime errorcode 2147467259

I can connect to my SAP Business Warehouse server. I used this tutorial, setting Environment Variables:  https://wiki.scn.sap.com/wiki/display/ABAPConn/Download+and+Installation+of+NW+RFC+SDK   Wh...
Need Help
mvpeterman's avatar
mvpeterman
Frequent Visitor
8 years ago

I am also receiving the same issue! I think it's the way Power BI is calling the data or something that is maxing out our memory in SAP BW since I could see the entire InfoProvider when I looked at it in BEx Analyzer. Has anyone come up with a solution or work around?

 

Thanks,

Anonymous's avatar
Anonymous
Not applicable
8 years ago

no... so far, the best option is to adjust SAP BW in small cubes, this way the conversion is faster and does not run out of available memory and resources.

or use direct query in Power BI, but then you can only create measures. you cannot se data or relationship.

  • mvpeterman's avatar
    mvpeterman
    Frequent Visitor
    8 years ago

    Thank you DN for such a quick response! I'll let you know if I figure out a solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

     

    In direct query mode, it doesn't load the whole cube, but it do many small request with few axes, one by graph or visualisation.

    Same thing with analysis for office for exemple.

     

    In import mode, it try to load one big set of data with many axes so it use a lot more memory on SAP application server side.

    I think it's not a Power BI bug or a bad SAP configuration but more a concept weakness. Responsiveness of import mode come at a price...

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    We are having the same problem in my company.

     

    Is there any update on this topic? There have been some fixes implemented?

     

    Kind Regards