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

Power BI User on 05 Jul 2020 23:12:07

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

Some users are hard to convert to anything else except Excel.

WALTER's profile image Profile Picture

Michele Morris on 05 Jul 2020 23:11:56

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

My guess is that they won't do it because they want consumers of the reports to have to buy a PowerBI Pro license to view the reports. If they allow them to be exported as they are, then viewers would not have to buy the license as well. I agree, this kills my use case if we are not able to create the relationships and get the data back out in the same view to create actionable tasks from the data.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:11:55

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

When is this happening?

WALTER's profile image Profile Picture

Mike Thibodeaux on 05 Jul 2020 23:11:43

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

Wade's comment is the exact same for my company. It's getting exhausting explaining why it won't export like they see it in Power BI. Any chance of understanding if this is even on the road map?

"This is the #1 most complained about issue with our Power BI implementation. Every time my users go to export data to excel they escalate to me and tell me Power BI has a bug and isn't working. I have to explain to them that this is "As Intended", though this is far from what I intend this functionality to do."

WALTER's profile image Profile Picture

Ryan Fonash on 05 Jul 2020 23:11:19

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

yes, please. While many of us can quickly whip up a pivot table to match the display that was in the matrix, it is an unnecessary waste of time when summarized data needs to be shared with other user(s) with less technical knowledge and/or without access to Power BI.

WALTER's profile image Profile Picture

Krishna on 05 Jul 2020 23:11:19

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

Very important feature and is stopping us from implementing PowerBI full scale across our organization. Is this going to be released in near future?

WALTER's profile image Profile Picture

Wade on 05 Jul 2020 23:11:19

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

This is the #1 most complained about issue with our Power BI implementation. Every time my users go to export data to excel they escalate to me and tell me Power BI has a bug and isn't working. I have to explain to them that this is "As Intended", though this is far from what I intend this functionality to do.

WALTER's profile image Profile Picture

Andrea Carlini on 05 Jul 2020 23:11:17

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

This is a must, otherwise we will move away from Power BI and select better tools that actually perform this very well.

WALTER's profile image Profile Picture

kangboed on 05 Jul 2020 23:11:17

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

Is there any chance this feature will be release ?

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:10:34

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

Very usefull feature

Merged Idea (1)