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

Jason Campbell on 16 Mar 2021 01:56:58

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

I have to think that the ability to transform data, format it for end users and give them the ability to easily export it to Excel (another Microsoft product) is in the top 3, or maybe 5 use case scenarios.

It's unbelievable that this feature doesn't exist.

No, under no circumstances, will the paginated report visual suffice (May 2021 release). Not even close.

WALTER's profile image Profile Picture

Travis Stephenson on 15 Mar 2021 12:27:44

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

reality is that as awesome as PBI is some folks still need to take things into Excel or other applications to play with the data. We are doing lots and lots of work arounds because we can't just export the data as seen in the matrix into excel or other programs. Please get this enhancement ASAP. It will really help my company get off pivot tables and into PBI.

WALTER's profile image Profile Picture

Richard Valdez on 03 Mar 2021 21:37:41

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

This feature would be huge for me. I have multiple matrix visualizations in PowerBI that are run much faster and more efficiently than in Excel. I don't know what the wait is on this.

WALTER's profile image Profile Picture

Antony John on 02 Mar 2021 04:16:34

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

It is a key feature which is supported in most of the Basic BI tools. It is a major disadvantage for such a powerful tool..

WALTER's profile image Profile Picture

See Ling Wong on 25 Feb 2021 11:03:05

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

Need this. Why the review takes so long?

WALTER's profile image Profile Picture

Jad Karami on 19 Feb 2021 04:20:49

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

I cant reiterate any further how much of an impact will this functionality help. I sometimes have to jump into other BI tools just to get this done at a quicker speed. This will also help non-developers/administrators such as sales teams rely more on PowerBI once they have the ability to export visualizations as is into their reports especially when they do not have the ability to rebuild the visualizations based on raw data...

WALTER's profile image Profile Picture

Ajit Varsani on 17 Feb 2021 04:16:57

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

Please can this feature be implemented as I need to export data for my own reports.

WALTER's profile image Profile Picture

James Drever on 16 Feb 2021 12:25:33

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

I have no understanding why this clearly deeply needed change hasn't been made. It is such a fundamental weakness, it comes up repeatedly with actual users, please for the love of god implement it.

WALTER's profile image Profile Picture

on 09 Feb 2021 19:54:27

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

I can only speak for myself but not having this feature really degrades using Power BI in general for my purposes. Matter of fact, it's kind of shocking it's not offered.

WALTER's profile image Profile Picture

Glen McGrath on 03 Feb 2021 14:58:20

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

Would be a very useful feature. Lots of users use the export to Excel function

Merged Idea (1)