Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SatyaVaitla
Helper I
Helper I

no space available for extending an internal table when i click on edit query

i down loaded partial data from my SAP BW cube and as Power BI desktop could not distinguish my measures and dimensions, i clicked on edit query to change data type. I got the folloiwng error:

 

DataSource.Error: SAP Business Warehouse: SYSTEM_FAILURE No more storage space available for extending an internal table.
Details:
    DataSourceKind=SapBusinessWarehouse
    DataSourcePath=leapbwlbp/00/350
    ErrorCode=-2147467259

 

When the data is already downloaded, why i get this error?

DOES EDIT QUERY NEEDS MORE SPACE THAN THE DATA ITSELF?

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @SatyaVaitla,

 

Based on my research about the error "SAP Business Warehouse: SYSTEM_FAILURE No more storage space available for extending an internal table.", the issue is from SAP related to the internal tables used. I have found some threads about this error, you can take a look:

 

SAP BW problem when extract

No more storage space available for extending an internal table

 

In your scenario, I would suggest you ask SAP System Admin to analyze the issue on SAP side.

 

In addition, after importing data to Power BI Desktop, we are able to create a measure without opening Query Editor. Please refer to this article: Tutorial: Create your own measures in Power BI Desktop.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ankitpatira
Community Champion
Community Champion

@SatyaVaitla Guessing from the error to troubleshoot, can you load a little less data than what you're doing now and use edit query ?

yes. with less data it was working fine.

 

I allotted abot 15GB in the File>options>dataload

 

i am using windows and MAC

 

With SAP the data is always big. Even in present case i loaded only small portion of my cube (by selecting only very few measures and dimensions).

 

My data is available in data window and also in report window ( i can not create any report because all my measures are treated as text by power bi desktop!). So i need query editor

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.