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?

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

        Hi Anonymous,

        In the blog, it said you get data from SQL Server database. We can add T-SQL command under the “Advanced options” section in data source dialogs. For example, we can use T-SQL @@LOCK_TIMEOUT function to set the timeout.

        Best Regards,
        Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Angelia. Please, where or what should I look for in the trace log?

      any error code, script sequence?

      there is a lot of empty files as well...

       

      What kind of private information if there inside the trace log? I am not sure I am allowed to shared it...

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

        Hi @DN,

        For looking for trace log, please review and follow this blog.

        If there is private information you're worried about. You can create a support ticket on the right bottom to check your issue, which is safe.

        Best Regards,
        Angelia