Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
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
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.
@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.
@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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 37 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 68 | |
| 34 | |
| 33 | |
| 30 |