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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I retested some queries (cubes) in SAP BW...

It seems that this runtime error actually is the limit of 750k cells from SAP BW.

SAP BW returns a maximum of 750.000 cells. If Power BI tries to read a cube bigger than 750k cells, SAP BW locks up and the error comes in on Power BI.

Can someone please confirm this?

 

Some people have suggested to change SAP BW to SAP HANA, is it worth it?
Does SAP HANA have a cell limit like SAP BW?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    One more test:

    I loaded 5 months worth of data from my SAP BW server, total of 2.047.072 cells.

    Way more cells than the 750.000 original limit from SAP BW.

    Average of 409k cells per month.
    I cannot load 6 months of data. Using the average, it should get a total of 2.456.486 cells.
    So I think this limit if from Power BI itself, not from SAP BW...

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi Anonymous,

      Please enable the Power BI desktop trace log, then repeat the steps to connect to SAP BW, share the trace file with us. You can upload files to OneDrive and share the link here.
       
      Best Regards,
      Angelia

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Ok, understood. But I am no longer with access to SAP BW server. I asked my coworker to try and enable trace log while performing the data load. As soon as I have the trace log file, I will share it here.

         

        About the timeout option, there is an option to set timeout command, according to this March update.
        https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-update-feature-summary/
        But where should I use this command? Inside the MDX box?
        What are the correct syntax and parameters?

        Could someone please provide an example of this command?