Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |