Skip to main content

    Power BI

    Needs Votes

    Allow Table and Matrix Data Exports to Match PowerBI Visual

    Vote (4721) Share
    WALTER's profile image

    WALTER on 12 Jul 2016 18:08:52

    I have volumes of information to share with my teams that is best presented in tables and matrices. It would be a huge improvement if they were able to export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.

    This would be especially helpful for ongoing forecasting activities.

    Administrator on 27 Jul 2020 18:00:47

    Thanks for your feedback on this issue - while we'd like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn't a solution everyone can take advantage of currently.

    Comments (692)
    WALTER's profile image Profile Picture

    8b7de40a df56-4e94-9698-95ae9284a9c8 on 05 Jul 2020 22:46:35

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    we need this

    WALTER's profile image Profile Picture

    65070b57 77e2-422b-913c-c9aa6affeef3 on 05 Jul 2020 22:45:35

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    We absolutely need this. Please everyone vote for this!!!!! This is going to be a deal breaker for us to convince clients to go with Power BI. We're trying to overcome this now with a client. Very frustrating and disappointing this isn't already developed!

    WALTER's profile image Profile Picture

    6b5fb0c1 2f93-428d-a5c1-3442098bd088 on 05 Jul 2020 22:45:31

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    We need this requirement

    WALTER's profile image Profile Picture

    c91f4e34 6e6e-4cab-94b0-84a66846ebc9 on 05 Jul 2020 22:45:06

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Without this feature one of our large group wide teams may not adopt Power BI.
    They are used to seeing data in the way it is presented in the Matrix visualisation.

    WALTER's profile image Profile Picture

    7b9665b8 4ab0-42d7-87a6-54bdec81d6ff on 05 Jul 2020 22:44:55

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Agree end users dont want to have to go now pivot the data

    WALTER's profile image Profile Picture

    375d4093 9792-4c9d-b4bb-5737c6fb278a on 05 Jul 2020 22:44:43

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Without this feature the "power" of Power BI is compromised. Hope this natural feature is introduced soon.

    WALTER's profile image Profile Picture

    b7964165 c36a-4f93-9358-187b950a8252 on 05 Jul 2020 22:44:09

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Yes! Please!!!

    WALTER's profile image Profile Picture

    d2730be4 23e4-448d-9ac4-a48b2e95d11c on 05 Jul 2020 22:44:09

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Seems like such a logical extension of the functionality.

    WALTER's profile image Profile Picture

    109e9f2f 4af6-4665-8783-1f1d65ab2cfa on 05 Jul 2020 22:43:48

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    Please provide it on priority, client may stop using power BI and will trust excel.

    WALTER's profile image Profile Picture

    29918ebf 093d-4303-bec4-000a150e0c7d on 05 Jul 2020 22:42:50

    RE: Allow Table and Matrix Data Exports to Match PowerBI Visual

    This is definitely a crucial capability as there are a number of times that spontaneous ad-hoc analysis needs to be done with the data and/or to incorporate the data into existing spreadsheet models. It is not practical to have to manipulate the exported .csv data back into the format that you need. Most BI tools already allow for this...

    Thanks