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
About "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf5 hours agoFrequent VisitorNew48Views3likes2CommentsEventstream MQTT broker source: V3.1.1 support
The Eventstream MQTT broker source supports connections with public MQTT brokers that offer MQTT V5 support. Please offer support for V3.1.1 too, because this is still a valid and widely used ver...svelde7 hours agoSuper UserCompleted1.4KViews6likes4CommentsGet data from Apache Kafka topics via private networking
Current prerequisites limit to public Kafka instances which is not feasible for most enterprise customers. When will this limitation be lifted so that it can be used in private network setups, for ...Jugi7 hours agoMicrosoft EmployeePlanned3.5KViews2likes3CommentsSet default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg15 hours agoNew MemberNeeds Votes7.8KViews1154likes104Comments