Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Greeting lovely members .
im trying to import a matrix from Power BI to Excel for my client . The problem when im trying import the matrix using the import function that exist in Power BI , it transforms the matrix into a table
here an exemple :
That's the matrix on my Power BI .
here what the import function generates . as u can see it transforms my matrix into a table .
is there a way to import the exact matrix using another third party without passing by the pivot function .
Thanks all in advance .
Solved! Go to Solution.
Hi @Anonymous ,
You export a visual or report to PDF if you want the formatting to be kept. But if you want to export visual to CSV or Excel, it would be flattened.
I suggest you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous ,
You export a visual or report to PDF if you want the formatting to be kept. But if you want to export visual to CSV or Excel, it would be flattened.
I suggest you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
You could publish the Power BI model then connect to excel:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-excel
Then you can build pivot tables. Be aware you will have to transform everything in the values section to measures, as you can only use measures in the values of a pivot table.
Here's a way you can do that using Tabular Editor:
https://exceleratorbi.com.au/introduction-to-tabular-editor-for-business-users/
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |