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)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
With over 5,000 votes in favor, why is this no longer listed among "Top Ideas"? As Jamie asked on 11/02, how many votes does this need, Microsoft? I'm tired of telling our users that they can't simply copy and paste a matrix into Excel as it appears within PBI. Microsoft, please give us this functionality.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Following up on my comment a few moments ago, I searched the internet and found another forum that had a link to Power BI Ideas. It took me to a Power BI Ideas thread titled "Allow Table and Matrix Exports to Match Power BI Visual" and shows 5,025 votes with comments as recent as 11/05/2020. As Jamie asked on 11/02, "how many votes does this need?". With over 5,000 in favor of it, why is this topic not listed among "Top Ideas". For all of you posting in favor within this thread, go out to the link below and see all of the comments there. Unfortunately, if Microsoft won't listen to 5,000+ votes in the other thread, I doubt they're going to listen to the 50 or so votes here.
https://ideas.powerbi.com/ideas/idea/?ideaid=b33fc4b3-9dae-4356-973d-d5ffe635ce15
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Until just recently, this topic was listed elsewhere on this forum and had a long list of comments in favor of it and had one of the highest vote totals (I think it was around 5,000 votes). Despite all of those votes, Microsoft said it "Needs Votes", just as it does here. I previously posted in favor of having this option, and I just came back to check its status and that particular topic appears to have been removed along with the many, many votes that people had for it. Microsoft, was it removed or am I overlooking it? We are replacing our current BI tool with Power BI, and everyone loves it - UNTIL I HAVE TO TELL THEM HOW THE EXPORT WORKS! This is a problem, Microsoft. It's ridiculous to dump all of the underlying data into Excel and and expect the users to recreate the calculations that already exist in PBI. PLEASE give us this functionality in Power BI.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is very important! And we have no ways to fix. Please implement this.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
I will definitely recommend Qlikview, this is too essential for end users who work with a lot of data
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Coming from Qlikview this is absolutely a must have function, our team expects not to lose this feature after using it for years on a daily basis. Deal breaker.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
How many votes does this need?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
In addition to this please consider our request too for the matrix visual in power BI which is allow filter conditions on Columns field in the matrix visual.
Please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=64f4fe06-de11-eb11-8441-0003ff52809c
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
BI Helper Matrix is a 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
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
So ridiculous to have to deal with this still today, knowing there is SSRS since the early 2000's and other BI tools allow this seamlessly