Issue
Repeated data source credential prompts will occur when loading a SAP BW connected view from Tableau Desktop.
Last Modified Date: 18 Jul 2022
Environment
- Tableau Desktop 2020.4 and newer
- SAP NetWeaver Business Warehouse
Resolution
Limit the SAP BW query cells to 1 million.Cause
There is a 1 million cell result limit to an MDX query for SAP BW.Additional Information
The Tableau Desktop logs will have the following error:Database error 0x80040E14: Dataset is too large. It has more than one million cells.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials