Showing results for 
Search instead for 
Did you mean: 
New Member

Want to Export Matrix from Power BI to Excel

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 Image 1.jpeg

Community Support
Community Support

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

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


Super User
Super User

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


Refer if this option can help

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

@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

Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors