How can we improve Power BI?

Allow export of summarized data

Power BI leads the user to believe it is possible to export summarized data at the level of the current view. In fact, the result of [Matrix grid] > Ellipsis > Export data is that data is exported at the lowest level of the drill-down path.

In one case, I am viewing 4 rows of data in my matrix grid (drilled up to the top level of the data hierarchy). When I export to xlsx, i get over 15,000 rows of data (summarized at the lowest level of my data hierarchy).

Users should be able to export data at the level they are currently drilled down to on their report.

118 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

15 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Please add this feature. It is easier for the users to export the exact data they need.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please add this feature. I allow details in my matrix columns to drill down for further insight but at whatever level the user is viewing the data should be an option for exporting.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please allow this feature in the 'Line and Stacked Column Chart'! It would allow ease of use for exporting data out of timeplots.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is a readily available feature in competing data visualization products and should not be missing from Power BI's feature set!

  • Jason commented  ·   ·  Flag as inappropriate

    This feature is critical to be able to use these reports as we need.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please also allow this on other hierarchy enabled visuals like time plots by date

  • Briton Wells commented  ·   ·  Flag as inappropriate

    This would be nice to have - especially for date hierarchies, users currently have to re-pivot the data in excel in order to roll up to the year, for example.

  • JL commented  ·   ·  Flag as inappropriate

    This is a feature that is highly desired by users so that they can export at any level and also export what they see on the report. Please add this feature as soon as possible

  • Anonymous commented  ·   ·  Flag as inappropriate

    This feature has to be added ASAP. Users need it on high priority so that they can export at any level they are viewing.

  • Alex Abell commented  ·   ·  Flag as inappropriate

    I 100% need this functionality! For now, I have to create a duplicate page with the visual's lower levels removed. Definitely not ideal.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.