Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
JulienZH
Helper I
Helper I

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

JulienZH_1-1662478894087.png

 

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

View solution in original post

7 REPLIES 7
sapientcompany
Advocate II
Advocate II

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 🙂

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

JulienZH
Helper I
Helper I

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

Shahfaisal
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.