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

    2d6a235c 7918-4c45-a297-646677ada369 on 06 Jul 2020 00:13:24

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

    Hi, This is very import features for our customers to export data in matrix format as our traditional reporting tool was supporting this. Can you please let us know as when this will be available in Power BI?

    Thanks,
    Nalini

    WALTER's profile image Profile Picture

    9fe3b436 1ad2-4adc-b2b1-df65640f5304 on 06 Jul 2020 00:13:22

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

    '@microsoft - can we get an explanation as to why this will not be worked on and no time timetable? There is sooo much pent up demand for this feature from customers.

    You should see the expression of the common user go from this product is awesome to, wait, this won't export in the right format? It is the face you get when you find a hair in your food at a restaurant.

    This is number one thing I tell people now to manage their expectation on PBI. They usually go a different route knowing PBI does not have this functionality for end users.

    WALTER's profile image Profile Picture

    ed3190c7 f501-49bf-840d-1d417c324576 on 06 Jul 2020 00:13:21

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

    Please, this is really required and have been available in products such as Qlikview for ages...

    WALTER's profile image Profile Picture

    86374178 0710-4ec2-bd81-6990bbf73f3b on 06 Jul 2020 00:13:04

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

    Please enable this feature as users want to export the data from Visual to Excel in pivot form

    WALTER's profile image Profile Picture

    f813ceec 7140-4684-b791-aec98f46794d on 06 Jul 2020 00:12:51

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

    Please enable this option of Matrix Data export to Match PBI, Whereas Other Competitors like Qlikview & Tableau has this beautiful feature which is very much needed.

    WALTER's profile image Profile Picture

    7b63c4fd 1949-483a-9e7e-0b33f3bfec1f on 06 Jul 2020 00:12:46

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

    Needed this feature.

    WALTER's profile image Profile Picture

    1415882d 3342-4c52-ace7-b79f18716940 on 06 Jul 2020 00:12:46

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

    Please develop - greatly needed for the common PBI report user...

    WALTER's profile image Profile Picture

    63af6af8 9a7b-4c7b-a9c7-f399ced56adf on 06 Jul 2020 00:12:44

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

    Please. Seriously.

    WALTER's profile image Profile Picture

    8d6d668d cebb-4628-b6ed-54b81e1740eb on 06 Jul 2020 00:12:29

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

    Really needed function

    WALTER's profile image Profile Picture

    bc2e3fe0 36fb-4b8d-8f6b-1aebbc7f45d8 on 06 Jul 2020 00:12:21

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

    BI Helper Matrix 4.0: The complete solution for formatted data export of table and matrix visuals

    Go to https://bihelper.tech/bihelper_matrix.html.

    Visual formatting and matrix data pivots retained in Excel download.

    Secure Microsoft login - use your Power BI login to access Matrix 4.0.

    Free 14 day trial.