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:18:33

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

We understand that PBI subscription model is quite cheaper than to offer by competitions. However, PBI and MS team cannot overlook their own product MS Excel utilization in market. I strongly believe this feature is a HIGHLY needed feature in the market.

WALTER's profile image Profile Picture

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

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

Need this functionality to prepare external exports from BI files. Please add this feature to BI capabilities.

WALTER's profile image Profile Picture

Jenna Stone on 05 Jul 2020 23:18:26

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

Very much need this functionality! We don't want to give people access to the underlying data, but do need to be able to give them totals in a summary table format.

WALTER's profile image Profile Picture

n on 05 Jul 2020 23:18:21

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

This is basic functionality.
Please do it ASAP

Thanks
Niasha

WALTER's profile image Profile Picture

Jess on 05 Jul 2020 23:18:20

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

This lack of functionality is extremely frustrating, We have many users who need the summarized detail from a single visual or request an ad-hoc copy of detail and do not need access to the entire dashboard. It would be helpful to simply share an export with them.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:51

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

Download visible values or something like that would be fine for everyone we support...
This could be a starting point at least.
I can understand the complexity of having it in a already pivoted format with drill down functionality when downloading, but all we need is for it to be pasted as is.
Please get this added ASAP.

WALTER's profile image Profile Picture

James on 05 Jul 2020 23:17:48

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

This is a must. How many votes are needed to get this needed feature to be sooner on the time line? We can already export data to Excel from PowerBI.com so I can't imagine it would be that complex to get a matrix to export in a table format. Thanks!

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:47

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

Please get this added as soon as possible. We are loosing clients due to this limitation.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:47

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

Please get this added as soon as possible. We are loosing clients due to this limitation!!!

WALTER's profile image Profile Picture

Frank on 05 Jul 2020 23:17:47

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

Lack of export capabilities in PowerBI is huge drawback and causes a lot of inefficiencies. I have to duplicate my PowerBI reports in Excel every time I want to share something other than a screenshot with colleagues, clients and contractors. Huge waste of time!

Merged Idea (1)