10-14-2016 01:14 PM
The drill-down functionality is wonderful, but (imo) it doesn't work correctly with respect to exporting the data. I want my users to be able to export exactly what they are looking at (WYSIWYG). Instead, what they get, is, regardless of the level of drill-down, the lowest level of detail. This is not useful!
If I have a sales chart with the following drill-downs:
and I'm viewing it at the highest level, Region, I can right-click and See Data, at which point I will be looking at the same summary data as is visualized, i.e., (for example) a small table with 4 regions and their respective sales data. Unfortunately, I cannot in any way select or grab those numbers. If I then try to get that same data by using Export Data, what I get is the hundreds or thousands of rows of customer-level data.
This leaves me having to waste real estate by duplicating the same visual once for each level of drill-down that my users need to access.
Would love to hear from others on this issue, and know if there's already a suggestion to address this issue on the ideas forum (I've searched on the subject, but been unable to find anything along these lines.
10-20-2016 12:45 AM - edited 11-02-2016 11:58 PM
I have tested it on our local environment, we can reproduce this issue.
It seems that it's default setting to export all the records from current level to lowest level. And based on my research, there is no such a functionally to only export only current level data.
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.https://ideas.powerbi.com/forums/265200-power-bi-ideas
10-20-2016 09:35 AM
I don't understand your response.
You seem to both say that it's a bug ("we can reproduce this issue") and that it's already resolved ("there is such a functionally to only export only current level data.")
You say there's a setting ("it's default setting to export all the records from current level to lowest level") but you don't indicate how we can access that setting...
Then you conclude by telling me to enter it as a feature request... (which tilts back towards bug...) I will do so. Sigh.
11-03-2016 12:08 AM - edited 11-03-2016 12:13 AM
Sorry for the confusion.
Power BI export all the records from current level to lowest level by default. This is not a bug.
What you want is that only export current level data. It's a feature request.
01-04-2019 07:41 AM
Has there been any movement on this feature request? Further, I have found that my total rows do not export either. These seem like massive oversights given that many people have the impression that Power BI and Excel pair well together.