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

Alastair Pickering on 05 Jul 2020 23:25:38

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

Been + two years since this idea was posted - as per the comments this is a must for business users!

WALTER's profile image Profile Picture

Jack on 05 Jul 2020 23:25:13

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

As many other users already commented, export Power BI reports/matrix to Excel or PDF with proper format is a basic feature of many established BI tools. We are losing business users because of the lack of this feature. Can this be worked as the first priority?

WALTER's profile image Profile Picture

terry on 05 Jul 2020 23:24:57

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

This request is a very basic function and part of the sell in power bi is you can provide the information but retain control of the data , however if the only way you let people get finished tables out for inclusion in other reports, work etc is to export potentially misleading data tables, then it is a serious issue. It simply needs be like the copy table function , copy what is the data displayed at the time , no other data , no drill downs, no formulas just a simple capture of the matrix table as it is shown. basic formatting would be great but not even essential.

WALTER's profile image Profile Picture

Aaron Power BI User on 05 Jul 2020 23:24:48

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

Export to Excel is one of many half-baked feature found in Power BI that kills it's adoption.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:40

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

Please prioritize this feature

WALTER's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:24:40

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

I dont know what excuse to give my business users regarding this seemingly obvious feature.

WALTER's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:36

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

Our field people always exports the data into excel . They had to pivot the data every day they import the data. Must need feature.

WALTER's profile image Profile Picture

Yolanda on 05 Jul 2020 23:24:24

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

Celebrating 2 years anniversary of this post.

WALTER's profile image Profile Picture

Meirav on 05 Jul 2020 23:24:20

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

agree we really need this feature

WALTER's profile image Profile Picture

Terry hull on 05 Jul 2020 23:24:01

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

The absence of this feature or even a simple ability to do a copy similar to the copy-table in tables is very frustrating to all users. everyone is right these types of omissions simply make power bi a 2nd rate product when used by the real world. we move our people to products like power bi to save them time and keep them focused on the real task but having to then recreate and manipulate data simply defeats the purpose.

Merged Idea (1)