Analyse in Excel drillthrough not working (returns 1)

[JulienZH]

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.

[sapientcompany]

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

[JulienZH]

Unfortunately no, that remained a mystery ... ;(

[sapientcompany · Accepted solution]

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]

Oh, good to know! I indeed have a measure table. Thanks 🙂

[sapientcompany]

I believe this is a bug.  Where the measure is organized should have no effect on the actual expression.

[JulienZH]

There's definitely more than one row, that's for sure.

[Shahfaisal]

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