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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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