Forum Discussion
Advocate IMatrix Export - "Data with Current Layout" Not Showing as an Option...not even greyed out
Hello,
I have an end user that was unable to export the data from a matrix table today. As it turns out, they cannot even see the "Data with Current Layout" in this report. The settings enable exporting of current layout and summarized data, not underlying. I've never seen this simple option go missing. My team and I do not have this problem and I cannot find a setting in the dataset or the report that would limit this function. The end user can also export tables in other reports, just not this one.
Can anybody help me on places to look to fix this?
User: Free License
Workspace: Premium (per capacity)
Dataset: PBI Dataset housed in difference Workspace (with all datasets)
Thanks in advance!
4 Replies
- collinq
Super User
Hi Josh_Boj ,
Is there RLS on this data? Also, according to this link: Export data from a Power BI visualization - Power BI | Microsoft Docs
"
-
Export using Underlying data won't work if:
-
the version is older than 2016.
-
the tables in the model don't have a unique key.
-
an administrator or report designer has disabled this feature.
-
you enable the Show items with no data option for the visualization Power BI is exporting.
-
-
For export from matrix visuals using Data with current layout, consider the following:
-
Matrices with columns and/or values but no rows will be exported as having rows and/or values but no columns
-
Matrices with only one row and/or values but no columns will be exported as table (no right border separator)
-
If the Show on rows toggle is set to 'On' in Power BI Desktop for a table or matrix visual, the visual format would not be preserved when data is exported to Excel
-
If the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows. To work around this issue, use the Expand | All command from the visual's context menu."
-
Josh_Boj"For export from matrix visuals using Data with current layout, consider the following:"
All of these comments are related to the export itself. My issue is that this one single user doesn't even have that option when everybody in the organization does. Makes no sense to me.
-
