question

GaryLock-CQC avatar image
0 Votes"
GaryLock-CQC asked GaryLock-CQC commented

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

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!

office-excel-itproazure-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
1 Vote"
emilyhua-msft answered GaryLock-CQC commented

@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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

*Microsoft Excel for Microsoft 365 MSO (16.0.13530.20132) 64-bit

0 Votes 0 ·
HarithaMaddi-MSFT avatar image
1 Vote"
HarithaMaddi-MSFT answered GaryLock-CQC commented

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.


· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

1 Vote 1 ·

Hi @GaryLock-9707,

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

0 Votes 0 ·

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

0 Votes 0 ·
Show more comments