An Unexpected Error Occurred - Live Connection to SSAS

[Anonymous]

Hey Everyone, 

I tried sifting through other questions like this but couldn't seem to an answer. Sorry if I missed something and this is a duplicate question! 

I am using a live connection to SSAS (13.0.4604.0) and on some visuals I keep getting the error message: "Can't display the visual. See details."

• See details give the message: "An unexpected exception occurred."

I am seeing that this has happened with some versions of SSAS that were fixed with updates but we are running the most up-to-date version of SQL Server 2019 SP1 (as far as I can tell at least).

Is there any way that this could be a memory issue instead of a SQL Server version issue? 

Thank you in advance! 

[Anonymous · Accepted solution]

Forgot to post an update on this... Updating SQL Server seems to have solved this issue

[V-lianl-msft]

Hi @Anonymous ,

Do you apply the measure you created in this visual?

Wrong measure can cause this issue, and you can check the calculation logic of the measure for errors.

You can also refer to this:

https://docs.microsoft.com/en-us/archive/blogs/sqlblog/what-is-ssas-error-an-unexpected-exception-oc... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , can you click on see details and show error