Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Na12
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

5 REPLIES 5
v-easonf-msft
Community Support
Community Support

Hi, @Na12 

As mentioned by @Anonymous ,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.  

 

amitchandak
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

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

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

Anonymous
Not applicable

@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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.