Skip to main content

    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 (822)
    WALTER's profile image Profile Picture

    Trien on 05 Jul 2020 22:51:47

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

    The Matrix View in the Power BI interface is lacking many features that are available in Excel Pivot Tables.(Eg: Repeat data in all rows etc...). Users are unable to use Matrix View data for any further joining and linking to other data sets or tables since they cannot export the data to excel. Oracle BI is already having this feature with full fledged Pivot Table functionality. We hope Microsoft will implement this modification soon!

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:49:56

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

    PBI should be serious about our complaints and requests to remain competitive among other mature BI platforms.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:49:37

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

    Very much required for reporting

    WALTER's profile image Profile Picture

    Jon on 05 Jul 2020 22:49:13

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

    This is how Performance Point scorecards worked and it was great. Exporting data formatted, with summarized subtotals and grand totals is a must have!

    WALTER's profile image Profile Picture

    K V on 05 Jul 2020 22:49:02

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

    A definite must for any kind of reporting.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:48:27

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

    this is a must to have feature. Qlikview does it really well

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:48:13

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

    Agree.. To eliminate the double process from Power BI with Excel..Time consuming..

    WALTER's profile image Profile Picture

    Jeremiah Johnson on 05 Jul 2020 22:48:09

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

    This is big issue for our engineering group. It is time consuming & difficult to matrix constantly new data sets and then easily share them.

    WALTER's profile image Profile Picture

    K V on 05 Jul 2020 22:47:32

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

    Yes, agree - why would someone want to repeat the data manipulation in excel after having done that in Power BI.

    WALTER's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:47:13

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

    We need this function! Without this most of our reports on Power BI are useless for the end user when exported.

    Merged Idea (1)