Mar 03 2020 07:02 AM
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?
Mar 03 2020 10:48 PM
Mar 04 2020 06:55 AM
We have a power bi implementation but many of our users are connecting to SSAS using excel. Thanks for the reply. @PascalKTeam
Mar 04 2020 06:57 AM
Sep 14 2020 03:30 AM
@PascalKTeam No it's not. At the moment, there's no true alternative for the flexibility and awesomeness of the Excel pivottable. But the matrix is getting close...
On-topic: I have the same error. Very weird. I can browse the model without issues in SSMS.