Forum Discussion
JulienZH
Helper II
Helper IIAnalyse 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.
JulienZHHelper II
Helper IIThere's definitely more than one row, that's for sure.