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

Hannes K on 05 Jul 2020 23:13:07

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

It is always the first questions in my Power BI trainings - if it is possible to copy/paste the underlying data into Excel? So now it is only possible to see them in a table (show data), which is very cool, but it would be great to copy them from this table directly to Excel to do further calculations. CSV export doesn't work very properly with SSAS live connections.

WALTER's profile image Profile Picture

Claudia Machado on 05 Jul 2020 23:13:07

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

I manage a report team that provides information toa sales Department (aprox.100 people), at all levels of the hierarchy. They all want dashboards, but also the data in excel to make some analysis of their own. This feature is very important, or we will have in many cases to stick to excel based reports.

WALTER's profile image Profile Picture

Rebecca on 05 Jul 2020 23:13:05

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

Please, please tell me this is coming soon. Please!

I currently am rolling out Power BI and people really like the look of the report in the service but when they export it to excel it completely changes the look of it. Also being able to export to PDF would be great.

WALTER's profile image Profile Picture

Geetanjali on 05 Jul 2020 23:13:00

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

This feature really helps the customer to get the exact view in excel as in power bi, to proceed their task further.

WALTER's profile image Profile Picture

Dennis on 05 Jul 2020 23:12:44

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

As Mike notes on Wade's comment, ditto for our company. We'd really appreciate a solution given Microsoft owns the whole suite in scope for this requested feature.

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

Jennifer on 05 Jul 2020 23:12:32

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

The lack of a proper export is a huge roadblock to adoption of Power BI in my organization. Getting very frustrating to explain why we (IT) can't fix it. We have many detailed drill down tables that users are trying to export summarized data from. It is difficult to explain that the "intended" behavior is to export the expanded hierarchy view, which takes it over the limit of rows that can be exported.

It is also annoying that the time out for the export is not communicated to the user.

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."

Merged Idea (1)