Forum Discussion
Export Data from Power BI (Matrix) into Excel
I have data in power bi in a Matrix form.
| ate | X | Y | Z | A |
| 2020-11-30 | 20 | 5 | 2 | 100 |
| 2020-10-30 | 10 | 15 | 20 | 10 |
But when I export the data , it gets exported in the following format
| Date | Ticker | Price |
| 2020-11-30 | X | 20 |
| 2020-11-30 | Y | 5 |
| 2020-11-30 | Z | 2 |
| 2020-11-30 | A | 100 |
| 2020-10-30 | X | 10 |
| 2020-10-30 | Y | 15 |
| 2020-10-30 | Z | 20 |
| 2020-10-30 | A | 10 |
4 Replies
Thanks!
its a nice tool but it doesnot dump the data as it is from Power BI. It creates the replica of the dimensions and tables used but I need an exact data dump.
Not possible as data,
but it should be fairly easy to replicate the matrix using the tool offered by sqlbi.com
Hi, Sachy123
It’s my pleasure to answer for you.
You should know that 'Export data' will export the raw data(original table) to csv file, not the format of a matrix data. As a workaround, you may try File-> Export to PDF instead in power bi desktop.
You can also refer to the similar post solution.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
