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 (819)
- Merged Idea (1)
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Sorry, and forgot to add, this is THE most requested feature from my users - second only to having the ability to rearrange a report columns and rows, which I saw is now possible in preview.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
For me this is way more important to have than the actual paginated reports. Paginated reports are tedious to format and build. The only reason I would build one is just to export the data in the same form as the visual. If this were possible natively in PBI, I wouldn't even need paginated reports.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
we really need this functionality
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This functionality is available in Tableau & QlikView. You would think this would be easy for Microsoft since they own Excel.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Please Microsoft.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
How does the 8th most popular idea still need votes?
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
Much needed one.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
All I can say is that I agree with all the other members, plus, Tableau can do it as we speak.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
This is an absolute must have. In our company were used to this type of functionality with other BI tools, like QlikView.
RE: Allow Table and Matrix Data Exports to Match PowerBI Visual
I want to follow up on my comment from yesterday. I've only been working in Power BI a few weeks, but I already see many advantages over our current BI tool that utilizes MDX. We already extensively use Excel's PowerPivot as a front-end to or SQL back-end, so bringing everything under the Microsoft umbrella makes sense to me. Which is why I am so disappointed to find that we can't export a matrix as it appears in PBI into Excel. This is such as fundamental request and NEED that I can't believe it was first proposed here over 4 years ago and still hasn't been incorporated into the product. Our employees shouldn't have to deal with having to further manipulate the underlying data once it's exported to Excel. That's the purpose of Power BI - eliminating the need for them to do that!! Even with all the limitations of our current BI product, it has had this feature for years. Please Microsoft, get this done.