Export Data from Power BI (Matrix) into Excel

[Sachy123]

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

[v-janeyg-msft]

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.

[PaulDBrown]

@Sachy123 

You can try using this free tool from the gurus at sqlbi.com

Tool to analyze in Excel 

[Sachy123]

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.

[PaulDBrown]

@Sachy123 

Not possible as data, 
but it should be fairly easy to replicate the matrix using the tool offered by sqlbi.com