Skip to main content
Microsoft Idea

    Power BI

    Completed

    Allow Table and Matrix Data Exports to Match PowerBI Visual

    Vote (6127) 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 13 May 2023 12:04:57

    Feature has been released in public preview.

    Comments (817)
    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:21:00

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

    We need an update on this immediately

    WALTER's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:20:48

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

    A must for the produt I had a shock when I found csv output for a matrix.

    WALTER's profile image Profile Picture

    Kevin T. on 05 Jul 2020 23:20:31

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

    Hi, this is something requested more and more by our customers..

    It's great to provide a nice experience through Power BI, but then, if they need to play with the data in Excel, exporting a Matrix will show a row data table, and they will need to create a pivot table (they don't always have sufficient knowledge to do that).

    Having the possibility to export to excel the fields as they appear in the matrix is a must have nowadays.

    Thank you

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:19:49

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

    Hi, Could we have any feedback please?..

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:19:34

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

    Hello Microsoft. When can we have this feature? At least provide a timeline.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:19:28

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

    Unacceptable not to have this feature

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:19:14

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

    Need this as soon as possible Business requirement

    WALTER's profile image Profile Picture

    anonymous on 05 Jul 2020 23:19:12

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

    This is a standard option with your competitor, Tableau. This should have been available day one. Why the continued delay? Why the disconnect so often between related Microsoft products?

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:18:59

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

    We need this feature. We have spent hours creating these visuals in PBI and need this to export. This will be an improvement that show the true benefits of PBI

    Thanks

    WALTER's profile image Profile Picture

    Pablo Moricz on 05 Jul 2020 23:18:46

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

    What I found as a workaround for now is:

    1)Publish report to power BI online service
    2)Pin it as a live dashboard to the Power BI online service
    3)Use the print option and then use the Print to PDF option.
    4)Use a PDF to Excel converter to get the data just as I want it in Excel.

    Merged Idea (1)