Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I created a matrix visual and i tried exporting the data to excel but it does not keep the pivot format. I read that currently there is no way to do it out of the box but there is a analyze in excel feature. However, it seems the end user would still have to build the pivot in excel even with this feature. Can anyone confirm that this is the case, and if there are any new added features that allows a straight export? The exported data does not even have to be a live connection. It is just purely for static reporting purpuses. Thanks.
Solved! Go to Solution.
Exactly!
Hey @wpf_ ,
the simple answer: there is no way. A matrix visual can not be exported/transferred into a Excel.
Even if both "objects" are looking similar, they are not.
You can consider creating an idea if it does not already exist. Look here: ideas.powerbi.com
Regards,
Tom
Thanks for the answer. So the only benefit of the analyze in excel option is not only can i build a pivot table out of my BI data, but that i can continually fetch new data with the same table over time, and I would only need to built the table that one time is that correct?
Exactly!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |