Is it possible to export data in a Matrix visual in a traditional row/column excel format instead of the tool converting it to a flat CSV file.
6 Comments
- chass
Impactful Individual
Hello Lisa, This is the current implementation. Moving your suggestion to the ideas forum Chuck - jshanahan1New MemberPlease provide a matrix 'export data' feature which exports the visual to excel as it is filtered and shown in the visual. It currently exports many additional columns and requires the user to re-format / pivot in excel (many steps)...
- kenl235New MemberI agree with Jeff. It would be amazing to have the option to export the exact layout of data the matrix is showing. Dropping into a flat format that you have to reformat is not helpful and defeats the purpose of using power bi. I could just do this in excel in the first place. I get there is underlying data but seems like there should be a copy and paste as is feature. There are several ideas similar to this floating around the site hopefully they are consolidated at some point and addressed.
- Robert_William3New Member4 years after the original suggestion, and we are no closer. I'm guessing this is the same for PBI service users as well (I use PBIRS) but exporting matrix from PBI report just drops ALL the data into CSV format which is not suitable for users who have no clue what to do with that data or how to group it up again in excel. Needs option to export matrix with data grouped (excel format), or even just export what is seen on the screen in that moment, without the ability to drill down/ungroup.
- nishalitNew Member
Exporting a matrix while retaining the layout of the matrix is now supported in the Power BI service
- fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v1 hour agoCommunity ChampionNew13Views1like0CommentsJustification Prompts When Downgrading or Removing Sensitivity Labels in Power BI Desktop
Description Currently, organizations can configure Microsoft Purview sensitivity label policies to require users to provide a justification when removing a label or lowering its classification. T...vvargasv17 hours agoMicrosoft EmployeeNew11Views0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley18 hours agoAdvocate IINew53Views7likes0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente19 hours agoRegular VisitorNew79Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez2119 hours agoNew MemberNew20Views4likes1Comment