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

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.

WALTER's profile image Profile Picture

Chris on 06 Jul 2020 00:17:01

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

Are there any updates on this feature since January? This is critical and, from a user standpoint, basic missing functionality between two Microsoft products.

WALTER's profile image Profile Picture

Grant Bertoli on 06 Jul 2020 00:16:39

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

This is the biggest deficiency I see with Power BI, 4,000 votes!!!!. End users need to quickly be able to cut and past into excel.

Until this happens I am still building functions in excel from the ground up.







WALTER's profile image Profile Picture

Moath Al Jammaz on 06 Jul 2020 00:16:23

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

Gail Sander on 06 Jul 2020 00:16:21

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

Please add this feature! Even if I could export to PDF and show the ENTIRE matrix instead of just one page would be helpful.

Merged Idea (1)