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

G F on 07 Jul 2021 16:13:18

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

Clients are stick on Qkliview only because of this ability... I am waiting for 3 year to export briliant matrixs to Excel to my clients and I am doing flows, tiles and etc instead... I had had it

WALTER's profile image Profile Picture

Sivanandan Ganesan on 06 Jul 2021 04:36:33

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

This is an import feature required by our users. We are using Qlikview(BI tool) and while downloading the Pivot table from Qlikview visualization to Microsoft Excel it is showing the same format. The Power BI and Excel both are Microsoft tools hence I don't think so to provide this feature is a challenge for Microsoft.

WALTER's profile image Profile Picture

Power BI on 01 Jul 2021 13:29:01

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

Can you please make this a top priority. It's tiring and time consuming having to find other solutions to generate reports for end users in excel every month, since that's the only format they accept.

WALTER's profile image Profile Picture

Mike Yeaton on 25 Jun 2021 14:34:01

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

Redundantly adding my voice to thousands of others eagerly awaiting this feature.

WALTER's profile image Profile Picture

Deena Power BI User on 24 Jun 2021 05:22:49

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

Please provide an update on expected release. Thanks

WALTER's profile image Profile Picture

Kiran Hosakote on 11 Jun 2021 09:32:00

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

See BI Helper Matrix - Chrome extension to export matrix and table visuals in Power BI to Excel. Retains visual formatting and matrix data pivots. Works with all tables and 2 x 2 (row x column) matrix drill-downs.

https://bihelper.tech/bihelper_matrix.html

14 day free trial.

Kiran Hosakote | BI Helper | contact@bihelper.tech

WALTER's profile image Profile Picture

Jason Campbell on 01 Jun 2021 22:24:47

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

Can't edit my initial comment.

Need to add: Adding a Report Builder (paginated report) visual is not the solution. Sure, maybe a workaround. I would think that the needs of most companies can be met w/out having to develop the dashboard and a paginated report.

Copy/export the matrix (and formatting) to excel.

WALTER's profile image Profile Picture

Jason Campbell on 01 Jun 2021 22:21:06

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

Excel is, by far, the most used app in the world for data analysis. How is that this functionality hasn't been in Power BI since inception? I mean, there are gaps and there are glaring omissions. It's safe to go with common sense on this one.

Can we please get more than a generic backlog status update? This lack of functionality/interoperability has significantly hindered our report migration.

WALTER's profile image Profile Picture

Anders Aano on 25 May 2021 07:05:28

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

Hi, Any updates to this? Release Wave 2 was scheduled from October 2020 to March 2021?

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/#:~:text=The%20Microsoft%20Power%20Platform%20release,Data%20Model%20and%20data%20integration.

WALTER's profile image Profile Picture

Sarah Nasr on 21 May 2021 18:02:56

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

Can't wait for this update ! Please fast track the release of this feature

Merged Idea (1)