Resources Exceeded This visual has exceeded the available resources. Try filtering to decrease the

[Azhagu]

Hi,

Getting visual has exceeded error with direct query connection to azure SQL containing around 4lakhs records. No complex DAX query but just sum and my model having only one fact table and 2 dimension tables

More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
Activity ID: 647d02d9-6041-4214-891d-c8452185c314
Correlation ID: 57237e79-5f9d-045a-e8f9-fd039caa5518
Request ID: a064c734-a20a-49ed-9dbc-54a5855f82df
Time: Thu Aug 24 2023 18:40:41 GMT+0530 (India Standard Time)
Service version: 13.0.21358.61

Thanks,
Client version: 2308.2.15305-train
Cluster URI: https://wabi-north-europe-h-primary-redirect.analysis.windows.net/

[aj1973]

@Azhagu 

Even a DAX with Sum could be better optimised. check it out