Fix Truncated Excel Results When Filtering an OLAP Cube
Question details
The user needs to fix an issue where filtering data connected to an OLAP or SSAS cube results in missing rows and truncated data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Filtering external data imported from an OLAP or SQL Server Analysis Services (SSAS) cube.
- Observed behavior
- The filtered results are unexpectedly truncated, causing expected rows of data to be missing from the spreadsheet view.
Ensure your internet or intranet connection to the database server is stable and verify that your user account has the necessary permissions to query the entire dataset from the SQL Server Analysis Services (SSAS) cube.
Update Microsoft 365 Apps to the Latest Version
Updating Excel can resolve known version-specific bugs related to OLAP cube data rendering and filtering truncations.
Microsoft frequently releases patches for Office applications to fix backend connection bugs. If data is being truncated selectively during OLAP filtering, applying the latest app updates through your administrator or application settings is the primary fix.
Open Microsoft Excel, click on the 'File' menu in the top left corner, and select 'Account' from the left sidebar.
Under the Product Information section, click on the 'Update Options' dropdown button.
Select 'Update Now' to force the application to download and install the newest software patches.
Once the update is complete, restart Excel, reconnect to your OLAP cube, and retest the filter to verify if all rows now appear correctly.

Seek Backend Support for SSAS-Specific Issues
If the problem is exclusive to OLAP or SSAS connections, the root cause may involve server-side cube configurations requiring specialized database support.
Try WPS Office for Seamless Data Management
If you are experiencing persistent issues with Microsoft Excel data handling or simply need a lightweight, high-performance spreadsheet tool, WPS Office is an excellent choice. It offers robust data filtering capabilities, extensive compatibility, and a familiar interface—all completely free.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Open your workbooks: Launch WPS Spreadsheet and easily open your existing .xlsx data files without worrying about formatting loss.
- 3. Analyze and filter data: Utilize the built-in sorting and filtering features to navigate your large datasets efficiently and without arbitrary truncation.

Frequently Asked Questions
Why does Excel truncate data when connecting to large OLAP cubes?
Excel may hit memory limits, backend MDX timeout thresholds, or encounter version-specific rendering bugs when parsing complex hierarchical data from OLAP cubes, causing the display to truncate results unexpectedly.
Can I increase the maximum number of rows returned from an SSAS cube in Excel?
Yes, you can adjust connection limits by going to the Data tab, clicking 'Queries & Connections', opening the Connection Properties, and modifying the 'Maximum Number of Records to Retrieve' setting under the Usage or Definition tab.
How do I know if the truncation is an Office app bug or a database limit?
Test querying the same data using a direct SQL query or a database management tool like SQL Server Management Studio (SSMS). If the data appears completely there but gets truncated in Excel, it is likely an Office application issue.
Does WPS Spreadsheet support analyzing large external datasets?
Yes, WPS Spreadsheet easily processes millions of rows of data and supports importing data from various external file formats and ODBC data sources, offering a fast and stable environment for heavy data analysis.




