KNOWLEDGE BASE

Error " The maximum number of dimension fields that can be imported is 49 due to limitations ofthe data source." When Creating an Extract with SAP BW


Published: 12 Apr 2019
Last Modified Date: 20 May 2019

Issue

Extract from SAP BW is created with data gaps.

Unable to complete action. 
There are too many dimension fields selected to import (55). The maximum number of dimension fields that can be imported is 49 due to limitations ofthe data source.
To enable import proceed. hide some dimensions to lower the number to less than 50.

Environment

  • Tableau Desktop 2018.1.2
  • SAP NetWeaver Business Warehouse

Resolution

As suggested in the error message, hide some dimensions to lower the number to less than 50. 

Cause

This behavior is related to a known SAP BW limitation. For more information about other SAP BW limitations, see SAP BW extract limitations in Tableau Help.
Did this article resolve the issue?