Want to Export Matrix from Power BI to Excel

[Na12]

Hii to everyone,

I want to export a matrix from Power BI to Excel. I know there are many ways to do this, but I want exactly same format of matrix as like of Power BI. I have alredy used many ways ways like export data and all but not able to get the exact output. Below I have a attached a image (this is the format of matrix in Power BI same I want in Excel).

Please help as soon as Possible.

Thanks in Advance 

[v-easonf-msft]

Hi, @Na12 

As mentioned by @NikhilKumar ,it doesn't  support that  export data of matrix visual in matrix form.

There is a same feature request posted in Power BI Idea forum, you can vote and comment on it: Allow Table and Matrix Data Exports to Match PowerBI Visual.

As a workaround, you can try to create a PowerPivot table in Excel. Or you can use PowerBI Tiles add-in in the Excel to get matrix visual. See: Integrating Power BI Tiles into Office documents.

Best Regards,
Community Support Team _ Eason

[danielpaduck]

Do you know if this has been implemented? I have a client that will not move forward with Power BI until this can happen.  

[amitchandak]

@Na12 , Export option is data export , so I doubt you can get the same format.

Refer if this option can help

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

[Na12]

No, I just only want to export a matrix not a dataset or something like this.

[NikhilKumar]

@Na12 You wouldn't get the same view of matrix what you see in Power BI.

However probably you can create the same view after exporting to excel