Capture SSAS drillthrough error for SSRS

Question

I have a MDX query which sometimes return the error
Drillthrough failed because the coordinate identified by the SELECT clause is out of range.
The data from this MDX query is used as the datasource for an SSRS report.
Is there anyway to monitor for this error so in the report, I could return a message to the use that "There was no data found".

This is the mdx
DRILLTHROUGH
Select (
[Measures].[Asset User Account - Added] ,
[Asset].[Asset].&[1] ,
[Asset User Account].[User Account Type].&[User]
) on 0 From [Asset]
RETURN [$Asset User Account].[Asset User Account] , [$Asset User Account].[User Account Description] , [$Date].[Date]

Answer 1

Hi @Terry St Jean
Do you mean that the message "There was no data found" is returned when there is no data in the report Tablix? Then you can use the NoRowMessage property in the Tablix properties.

Displayed normally when data can be retrieved.

Returns "There was no data found" when no data is found.

Best regards,
Aniya

Answer 2

I tried the suggestion of setting the NoRowsMessage but the message doesn't show because the underlying MDX query throws and error.

I guess I will have to figure a solution for the query first.