Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

liuhow

Got 'TSV_TNEW_PAGE_ALLOC_FAILED' issue when load data from BW

Submitted by on ‎11-20-2018 06:05 PM

Hello Expert,

when i tried to load data from BW part, after several hours ,i got error message 'TSV_TNEW_PAGE_ALLOC_FAILED'.

may i have your idea ?

Power BI Query Editor Error #1.pngPower BI Query Editor Error #2.png

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎11-21-2018 07:03 PM

Hi @liuhow,

 

1. Reduce the number of dimensions selected. Perhaps one measure and one dimension. If that prevents the error, please add dimensions one at a time. To determine if there's a specific dimension that's causing the issue.

 

2. Read the following blog article that describes a strategy for partitioning data from SAP BW:
https://businessintelligist.com/2018/03/24/how-to-overcome-sap-bw-memory-overflow-issue/

 

3. Read the SAP BW whitepaper, which includes best practices on the usage of the connector:
https://aka.ms/powerbiandsapbw

 

Best Regards,
Qiuyun Yu 

Idea Statuses