Azure Analysis Services and Excel - Maximum Page Size of the Storage Object

Gary Lock 16

I am unable to query an Azure Analysis Services model from Excel. I receive the following error:

Memory error: A record (99909 bytes) was encountered that exceeds the maximum page size of the storage object (65528 bytes).

Is there a setting I can use to increase the maximum page size?

The model itself processes fine and can be queried via Power BI Desktop without issue.

Thanks!

2 answers

Emily Hua-MSFT 27,651 Reputation points

2021-01-21T09:29:51.68+00:00

@GaryLock-9707
Do you use Office 32-bit?
If so, please install Office 64-bit to check this issue. The 32-bit environment is subject to 2 gigabytes (GB) of virtual address space.

From the perspective of Excel, we could not increase some Excel specifications and limits.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

1 person found this answer helpful.
Gary Lock 16 Reputation points

2021-01-21T18:19:10.84+00:00

Hello, I am using Office 64-bit and still receive the error.

*Microsoft Excel for Microsoft 365 MSO (16.0.13530.20132) 64-bit
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
HarithaMaddi-MSFT 10,136 Reputation points

2021-01-21T10:15:18.6+00:00
Hi @GaryLock-9707,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Please check this document for memory limitations on Excel and possible alternatives to overcome this issue. 32-bit Excel have more limitations compared to 64bit and also 2016 version of the Excel has enhanced memory capabilities. In addition to this, please check if there are multiple excel documents opened which might consume more memory.

Please let us know for further queries and we will be glad to assist.

--

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Please sign in to rate this answer.

1 person found this answer helpful.
Gary Lock 16 Reputation points

2021-01-21T19:51:58.693+00:00

I am using 64-bit Excel on a Surface Book 2 with 16 GB of memory. I get the error even though only one excel file is open.
*Microsoft Excel for Microsoft 365 MSO (16.0.13530.20132) 64-bit

It is a ~13GB AAS model that I am able to work with without issue in Power BI Desktop. I am able to connect to the model via Excel, but cannot query anything in the model with receiving the memory error.

I may have to look at creating smaller perspectives in the model to work with in Excel.

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-25T07:23:38.32+00:00

Hi @GaryLock-9707,

Please let us know if you are able to make it work in Excel with smaller perspectives in the model.

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-27T06:27:15.32+00:00

Hi @GaryLock-9707,

We have not received a response from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-28T05:36:25.993+00:00

Hi @GaryLock-9707,

We still have not heard back from you. Following up to check if you are still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.

Gary Lock 16 Reputation points

2021-02-09T16:37:27.287+00:00

Sorry for the delayed response. I never received a notification regarding your reply.

Creating smaller perspectives in the model allowed me to avoid the memory error. That's a less than ideal solution, but we'll make it work.

Thanks for your assistance.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure Analysis Services and Excel - Maximum Page Size of the Storage Object

2 answers

Your answer