Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |