March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Solved! Go to 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.
Did you ever figure this out? I am having same issue.
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.
I believe this is a bug. Where the measure is organized should have no effect on the actual expression.
There's definitely more than one row, that's for sure.
For the cell you doub-clicked on, maybe there is only one row in the data model. Can you verify that?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
37 | |
32 | |
20 | |
11 | |
8 |
User | Count |
---|---|
52 | |
42 | |
28 | |
12 | |
11 |