Forum Discussion
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...
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.
Did you ever figure this out? I am having same issue.
- Unfortunately no, that remained a mystery ... ;(
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.
- Oh, good to know! I indeed have a measure table. Thanks 🙂
