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 resu...
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.

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?