SAP Business warehouse: No more memory available to add more rows to an internal table.

[Anonymous]

Hi team,

When trying to fetch data from SAP BW in Power Bi desktop we are getting the below error.

SAP Business warehouse: No more memory available to add more rows to an internal table.

Please help us resolve this. 

Thanks,

Omkar

[Anonymous]

Hi @Anonymous 

Here I will give you some advise.

You may refer to this blog for more details about how to connect to SAP BW.

Please update your Power BI Desktop to the latest version. 

Please make sure that the processor is the same for both installations (32-bit vs 64-bit).

Here I find a post with same issue like yours, and you may refer to the last reply, he solved this issue by steps as below.

For reference: SAP BW connectivity issue

1. See OSS Note 1995588 . It descrives cause of error. ( But it's not intuitive rather confusing).

2. Place appropriate version of librfc32.dll on bin directory of BW server.(not client side)

    Above note claims required dll shoud be 32bit but in my case we needed 64bit version.

3. After placement , you maybe come across with another timeout error coming from ABAP program compilation.

   If so , after a second, you can try again and finally get data from BW. 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/