Share via

SSAS Tabular - Problem with drillthrough

Ben 1 Reputation point
2021-12-07T20:58:14.037+00:00

Hi !

I defined a simple Default Detail Rows Expression on one of the table of my SSAS Tabular model, and I'm experiencing a problem with the result.

My collegue has the same problem when he tries to use drillthrough, from the same tabular model, in Microsoft Excel.

When clicking "Show details" in Excel, a new spreadsheet opens up (like it should), but the only content I receive is what we see on this snapshot
155753-problem-with-drillthrough.png

Does anybody has an idea ?

Thank you very much !

Ben

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.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.