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
- chassImpactful IndividualHello 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
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v10 hours agoCommunity ChampionNew615Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v18 hours agoCommunity ChampionNew17Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal14019721 hours agoFrequent VisitorNew6Views0likes0Comments