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)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Unfortunately there doesn't seem to be a workaround other than exporting it yourself and creating a matrix in Excel yourself. Very time consuming and it's disappointing that it's only possible by upgrading to Premium and using the paginated reports. Unfortunately third party solutions like Power BI Robots can't do this either.
Come on Microsoft, this would make the quality of life when using Power BI so much better.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
What seems like a basic feature and is really required - looking forward to progress on this one.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Has anyone come up with a workaround for this using a 3rd party product?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Everyone vote as much as possible to put this on the top of the ideas. Maybe when its the top voted idea will they see we need this feature and understand how much we all want this.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
if you can not do it, just let every one know
instead of letting us checking and waiting for more than 4 years !!!
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This needs to be added as a feature. We currently use Analyze in Excel, but it is not an efficient solution for many.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
We are currently migrating a number of reports to Power BI whilst testing that the data matches, discovered that I cannot export the data into excel as a matrix - the other reporting tool used exported perfectly.
This means that we will need to work on the excel document which is adding extra time .. I was extremely surprised that I could not export a very simple matrix......
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Can you please add more detail on the suggested workaround in the Backlog response above? I don't understand what it means and how I would implement this. Thanks.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Since 2016 people asked for this and around 4000 votes, now almost we are in 2021, every month I update so hopefully Microsoft added this, till now it didn't
go to hill Microsoft
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
A valid reason for users to be upset. This request has been ongoing for such a long time and is part of the top 10 ideas now and microsoft still can't comment on a timeline. They probably can't get it right like Qlikview has. Not sure what reason for the lack of communication on this feature is Sujata. Your Team really needs to look into this. Users are really frustrated.