Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way to export a data from a Matrix to Excel in the Power BI Service? I cannot seem to find anything that works. I can export data from other types of visuals but it doesnt seem that I can with a Matrix. I do not have the "More Options" button in the top right of my visual.
Solved! Go to Solution.
Hi @tstackhouse
Is the matrix the one that comes with Power BI or did you import it from AppSource or your organizational store? Is it a custom visual?
If not, did you turn off visual headers?
Select the matrix > open Formatting pane > turn ON "Visual headers" > under "Visual headers" make sure all necessary icons are turned ON as well.
Let me know if this works,
Michele
Hi @tstackhouse
There are many reasons why you cannot export from your matrix. This is a good article to help -- especially the Limitations and considerations section at the bottom: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
The most common reasons are:
HTH
Michele
1.
Hi @mihart ,
It seems to just be this specific visual in the report. I do not even have the buttons to drill up, drill down, pin visual, etc. on this matrix. (See Picture 1) In other visuals on the same report I am able to see these options. (see Picture 2).
I thought it may be that a user does not have these options in the service. However, in another report I have created I am able to see all of these options. (see Picture 3) I am the creator of both reports shown. To me, it seems like there is something with that visual specifically.
Picture 1
Picture 2
Picture 3
Hi @tstackhouse
Is the matrix the one that comes with Power BI or did you import it from AppSource or your organizational store? Is it a custom visual?
If not, did you turn off visual headers?
Select the matrix > open Formatting pane > turn ON "Visual headers" > under "Visual headers" make sure all necessary icons are turned ON as well.
Let me know if this works,
Michele
It worked.
Thank you.
@mihart it is the Matrix that comes with Power BI. I did have Visual Headers turned off for some reason...? I am now able to export. Thank you!!