Forum Discussion

JulienZH's avatar
JulienZH
Icon for Helper II rankHelper II
4 years ago
Solved

Analyse in Excel drillthrough not working (returns 1)

 

Hi, I have a Excel pivot table connected to a Power BI dataset. When double clicking on a value, I always get .... 1. See screenshot. How come? Changing max rows to 1000000 doesn't change the result.

 

Need Help
  • sapientcompany's avatar
    sapientcompany
    3 years ago

    I just figured it out, at least in my case.  If you organize measures into a disconnected table in the dataset, then the drillthrough will not work in Excel.  If you move the measure to the table it was based off of then it will work.

7 Replies

  • Shahfaisal's avatar
    Shahfaisal
    Icon for Solution Sage rankSolution Sage
    4 years ago

    For the cell you doub-clicked on, maybe there is only one row in the data model. Can you verify that?

    • JulienZH's avatar
      JulienZH
      Icon for Helper II rankHelper II
      3 years ago
      Unfortunately no, that remained a mystery ... ;(
      • sapientcompany's avatar
        sapientcompany
        Icon for Advocate II rankAdvocate II
        3 years ago

        I just figured it out, at least in my case.  If you organize measures into a disconnected table in the dataset, then the drillthrough will not work in Excel.  If you move the measure to the table it was based off of then it will work.