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.

sapientcompany's avatar
sapientcompany
Icon for Advocate II rankAdvocate II
3 years ago

Did you ever figure this out?  I am having same issue.

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

      • JulienZH's avatar
        JulienZH
        Icon for Helper II rankHelper II
        3 years ago
        Oh, good to know! I indeed have a measure table. Thanks 🙂