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

Gary Lock 16 Reputation points
2021-01-20T22:56:13.623+00:00

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!

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 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.

    1 person found this answer helpful.
  2. HarithaMaddi-MSFT 10,126 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.
    1 person found this answer helpful.