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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.