Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Can't drill down into pivot cell based on tabular data model

  • 1.  Can't drill down into pivot cell based on tabular data model

    Posted May 15, 2019 01:38 PM
    HI, first time post.  I normally double-click a cell within the values section in an Excel pivot table to create a sheet with the records that correspond to that cell.  For my pivots based on tabular data models (e.g. classic data warehouse connections to SQL database tables), this does not work if there is a relationship defined in the data model (i.e. through Power Pivot).  Instead, a new sheet is created with an empty table.  I've searched everywhere for a solution and have found very little at all on this problem.

    Has anyone encountered this problem or know how to solve it?

    ------------------------------
    Jeff Nixon
    Managing Director
    The Shepherd Holding Company
    West Chester OH
    ------------------------------


  • 2.  RE: Can't drill down into pivot cell based on tabular data model

    Bronze Contributor
    Posted May 16, 2019 03:13 AM
    What version of Analysis Services are you running? Do you have a Detail Rows Expression set up?

    https://www.mssqltips.com/sqlservertip/5300/how-to-define-drillthrough-in-analysis-services-tabular-2017/

    ------------------------------
    Johnny Winter
    Business Intelligence Developer
    ------------------------------