Tuesday, April 26, 2022

Maximum Memory or File Size Exceeded [MS]

This message appears when the maximum memory or file size limit for a Data Model is exceeded. In the 32-bit version of Office, the maximum files size for a workbook containing a Data Model is 2 GB, and the maximum memory that can be consumed by a workbook is 4 GB. If you exceed either of these limits, the workbook cannot be saved.

If this occurs, you must reduce the number of tables, rows, or columns that are linked, imported, or copied to the Power Pivot window before you can save the workbook. There are two ways to do this:

Filtering data that has already been imported (as described in Filter Data in DAX Formulas) is not a solution for this error. Filtering imported data only affects how data is displayed.

Top of Page

No comments:

Post a Comment

Search This Blog

Remove the OneNote badge from the Android homescreen [MS]

Remove the OneNote badge from the Android homescreen OneNote for Android ...