Home

Excel SSAS Olap Connection Memory Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1206746%22%20slang%3D%22en-US%22%3EExcel%20SSAS%20Olap%20Connection%20Memory%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206746%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20an%20OLAP%20cube%20with%2030%20Facts%20tables%20containing%20on%20average%2015-20%20measures.%26nbsp%3B%20Around%2070%20dimensions%20in%20varying%20width%20but%20many%20are%20very%20fat%20containing%20over%20100%20dimension%20attributes.%26nbsp%3B%20Recently%20we%20added%20another%20field%20to%20the%20cube%20and%20when%20we%20try%20to%20connect%20using%20excel%20we%20get%20the%20following%20message.%26nbsp%3B%20%22Memory%20Error%3A%20A%20record(65789%20bytes)%20was%20encountered%20that%20exceeds%20the%20maximum%20page%20size%20of%20the%20storage%20object%20(65528)%20bytes%22%26nbsp%3B%20Have%20we%20reached%20a%20limitation%20in%20excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1206746%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208227%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SSAS%20Olap%20Connection%20Memory%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208227%22%20slang%3D%22en-US%22%3EIt%20sounds%20like%20it...%20You%20should%20use%20Power%20BI%20instead.%20Have%20you%20considered%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1209048%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SSAS%20Olap%20Connection%20Memory%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1209048%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20power%20bi%20implementation%20but%20many%20of%20our%20users%20are%20connecting%20to%20SSAS%20using%20excel.%26nbsp%3B%20%26nbsp%3BThanks%20for%20the%20reply.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1209051%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SSAS%20Olap%20Connection%20Memory%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1209051%22%20slang%3D%22en-US%22%3ESounds%20like%20there's%20something%20wrong%20with%20the%20Power%20BI%20implementation%20when%20people%20are%20still%20using%20Excel...%20Sorry%20I%20couldn't%20help%20more%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

We have an OLAP cube with 30 Facts tables containing on average 15-20 measures.  Around 70 dimensions in varying width but many are very fat containing over 100 dimension attributes.  Recently we added another field to the cube and when we try to connect using excel we get the following message.  "Memory Error: A record(65789 bytes) was encountered that exceeds the maximum page size of the storage object (65528) bytes"  Have we reached a limitation in excel?

3 Replies
Highlighted
It sounds like it... You should use Power BI instead. Have you considered this?
Highlighted

We have a power bi implementation but many of our users are connecting to SSAS using excel.   Thanks for the reply. @PascalKTeam 

Highlighted
Sounds like there's something wrong with the Power BI implementation when people are still using Excel... Sorry I couldn't help more