cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
JulienZH
Helper I
Helper I

Analyse in Excel drillthrough not working (returns 1)

‎09-06-2022 08:42 AM
 

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

 

Labels:
Message 1 of 3
121 Views
0
2 REPLIES 2
JulienZH
Helper I
Helper I

‎09-06-2022 09:23 AM

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

Message 3 of 3
79 Views
0
Shahfaisal
Solution Sage
Solution Sage

‎09-06-2022 09:08 AM

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

Message 2 of 3
85 Views
0

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

View All
Top Solution Authors
View All