Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I'm trying to get the data from a query in SAP BW HANA. However, there is one field that causing the issue as shown below. There is no issue with the other field as I can select and load it into the report.
I used to create the report with this query before, but somehow when I try to refresh the data today it shows the error message.
Please let me know if there is any information else that I need to provide.
DataSource.Error: The SAP BW server reported an error: 'Allocation failed ; $size$=144194406136; $name$=expr; $type$=pool; $inuse_count$=7; $allocated_size$=4472; $alignment$=8; ...'. To find more information about this error, visit the SAP support site and search for 'DBMAN 099'.
Details:
DataSourceKind=SapBusinessWarehouse
DataSourcePath=10.20.1.155/01/910
ID=DBMAN
NUMBER=099
MESSAGE_V1=Allocation failed ; $size$=144194406136;
MESSAGE_V2=$name$=expr; $type$=pool; $inuse_count$=7;
MESSAGE_V3=$allocated_size$=4472; $alignment$=8;
MESSAGE_V4=...
SYSTEM=BDPCLNT910
Command=SELECT
{
[Measures].[00O2THL5LBWKXF9PUT4BDPAXJ00O2THL5LBWMN8N0BRP2CU0FT]
}ON 0,
NON EMPTY DISTINCT(
[4ZCO_C001-EBELN].[LEVEL01].ALLMEMBERS
)
PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON 1
FROM [ZCO_C001/ZCO_C001_Q0004] CELL PROPERTIES VALUE SAP VARIABLES [!V000002] INCLUDING [0COMP_CODE].[US03] [ZCV_FP1] INCLUDING [0FISCPER].[K42021008] [!V000007] INCLUDING [0CURTYPE].[10]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.