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

Power BI User on 05 Jul 2020 23:27:46

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

I get this request from my users about 2-3 times PER DAY. It's what everyone expects intuitively.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:27:39

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

Get this added ASAP or feel the power of Thor's hammer :)

WALTER's profile image Profile Picture

David Forester on 05 Jul 2020 23:27:36

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

I can't believe this is a difficult feature to add. So why isn't it already in place? I can only assume there is a reason why (possibly best practice, ideological reasons or something along those lines) and hence it's unlikely to be added without a lot of pressure to do so.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:27:26

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

prioritise this!

WALTER's profile image Profile Picture

Alex on 05 Jul 2020 23:27:23

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

Much needed! Please prioritise this!

WALTER's profile image Profile Picture

Jeff Shanahan on 05 Jul 2020 23:27:19

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

We need a wysiwyg export for the matrix visual. This is the top request from our company user base and executive. It is embarrassing to explain to our users that this isn't possible already!

WALTER's profile image Profile Picture

Adam Kruzel on 05 Jul 2020 23:26:58

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

Very frustrating that for my users to export a pivot table to Excel, I must get involved and re-create measures and pivot table to replicate what's in Power BI. This seems like pretty low hanging fruit compared to other ideas that have more votes. There's the phrase that after OK and Cancel the next most used button is Export to Excel and not having this work fully is a pain.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:50

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

It's hard to convince some people that PBI is the way forward when we can't even let them play around with their data on excel because it is in matrix format

WALTER's profile image Profile Picture

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

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

How come Microsoft have a deaf ear to this? We have to move over ...

WALTER's profile image Profile Picture

sravan on 05 Jul 2020 23:26:44

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

Really needed update...Looking forward

Merged Idea (1)