SSAS error while exporting huge amount of data to Excel

Igor Zakharov 1 Reputation point
2022-04-06T14:48:35.147+00:00

Good afternoon,

We have a SSAS instance running on a VM with the sufficient amount of CPU and RAM.
Users connect to SSAS using Excel built-in connector and it works fine.

The problem arise, when users start trying to export data in pretty detailed way.
See the error description in attachment.

Tech-specialists, that are responsible for server-support, say there is no infrastructure-related problems, the connection is stable.

Could you tell, please, why could this happen?
What are the ways to solve the issue?

Thanks in advance!!

190577-error-ssas.png190612-error-ssas.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,255 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alexei Stoyanovsky 3,416 Reputation points
    2022-04-07T06:06:12.71+00:00

    Roses are red, violets are blue, SSAS is not designed for exporting prostynya of data, to Excel or otherwise.
    The specific error message is strange, though. What are the specific circumstances of its appearance?

    1 person found this answer helpful.
    0 comments No comments