Forum Discussion
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...
Thank you DN for such a quick response! I'll let you know if I figure out a solution.
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...