When data exported from a matrix, Power BI exports the underlying data for the report. Please allow the ability to export the data as how it's laid out in the report.
2 Comments
- Robert_William3New MemberI'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. I don't understand how this was created in 2017, and today in July 2020 it's is still outstanding, there are many "ideas" for matrix tables to be fixed. and how is this idea still in "new" status!
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Allow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara3 hours agoNew MemberNew4Views0likes0CommentsSupport Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi6 hours agoRegular VisitorNew1.3KViews18likes2CommentsExpose Refresh Warnings and Informational Messages via Notifications and API
When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention. Please pro...Jashwanth_K8 hours agoMicrosoft EmployeeNew23Views6likes0CommentsInvoke Pipeline Task - Workspace Identity Authentication
Currently, the Fabric Data Factory Invoke Pipeline task uses the user's credentials who saved the pipeline to then authenticate to the Azure Data Factory to execute the ADF pipeline. When that user'...dzebrowitz13 hours agoAdvocate IPlanned1.8KViews61likes5CommentsFabric Pipeline should run as workspace identity
Currently, Microsoft Fabric pipelines run under the identity of the last user who modified them, which can cause disruptions when tenant administrators make changes to security policies, such as enab...pellitteris13 hours agoAdvocate IINew1.4KViews27likes3Comments