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

Jeroen Groothedde on 11 Jul 2020 07:21:26

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

Unfortunately there doesn't seem to be a workaround other than exporting it yourself and creating a matrix in Excel yourself. Very time consuming and it's disappointing that it's only possible by upgrading to Premium and using the paginated reports. Unfortunately third party solutions like Power BI Robots can't do this either.

Come on Microsoft, this would make the quality of life when using Power BI so much better.

WALTER's profile image Profile Picture

Ben Marshall on 11 Jul 2020 04:26:50

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

What seems like a basic feature and is really required - looking forward to progress on this one.

WALTER's profile image Profile Picture

Maverick Baumer on 10 Jul 2020 17:22:46

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

Has anyone come up with a workaround for this using a 3rd party product?

WALTER's profile image Profile Picture

Power BI User on 10 Jul 2020 17:20:47

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

Everyone vote as much as possible to put this on the top of the ideas. Maybe when its the top voted idea will they see we need this feature and understand how much we all want this.

WALTER's profile image Profile Picture

duc thai on 10 Jul 2020 17:20:45

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

if you can not do it, just let every one know
instead of letting us checking and waiting for more than 4 years !!!

WALTER's profile image Profile Picture

Ryan on 10 Jul 2020 17:20:41

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

This needs to be added as a feature. We currently use Analyze in Excel, but it is not an efficient solution for many.

WALTER's profile image Profile Picture

Angelfish 42 on 10 Jul 2020 17:20:39

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

We are currently migrating a number of reports to Power BI whilst testing that the data matches, discovered that I cannot export the data into excel as a matrix - the other reporting tool used exported perfectly.

This means that we will need to work on the excel document which is adding extra time .. I was extremely surprised that I could not export a very simple matrix......

WALTER's profile image Profile Picture

Kirsty Younger on 06 Jul 2020 00:17:51

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

Can you please add more detail on the suggested workaround in the Backlog response above? I don't understand what it means and how I would implement this. Thanks.

WALTER's profile image Profile Picture

Moath Al Jammaz on 06 Jul 2020 00:17:51

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

Since 2016 people asked for this and around 4000 votes, now almost we are in 2021, every month I update so hopefully Microsoft added this, till now it didn't

go to hill Microsoft

WALTER's profile image Profile Picture

Power BI User on 06 Jul 2020 00:17:51

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

A valid reason for users to be upset. This request has been ongoing for such a long time and is part of the top 10 ideas now and microsoft still can't comment on a timeline. They probably can't get it right like Qlikview has. Not sure what reason for the lack of communication on this feature is Sujata. Your Team really needs to look into this. Users are really frustrated.

Merged Idea (1)