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.
Hello!
I am trying to export to Excel a matrix visual, I have placed the values to be shown on rows. This is what the matrix looks like in PowerBI Service:
However, when I export it using Data wtih Current Layout option, this is what I get in Excel:
Any help would be appreciated!
Solved! Go to Solution.
Hi @pulpfiction ,
According to my current test, it is normal, you can use my template for testing and compare with your own, also, is it possible to provide your pbix file, I will use your file for testing, remember to delete confidential data.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @pulpfiction ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @pulpfiction ,
According to my current test, it is normal, you can use my template for testing and compare with your own, also, is it possible to provide your pbix file, I will use your file for testing, remember to delete confidential data.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hello,
Apart from the idea there is a workaround here that I would like to share, please check if that helps
Solved: Exporting a Matrix visual to Excel - Microsoft Power BI Community
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin
You have chosen to "show values on rows" . Excel does not understand that feature. If this is important to you please consider raising it at https://ideas.powerbi.com