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.
When exporting a table/matrix from a Power BI report, the export file has the "Applied Filters" section with all filters applied.
Is there a setting to turn this off, so the export does not have this? I have hidden filters that the end-user does not need to see, but they come up on the export.
Solved! Go to Solution.
Hi @astano05
How did you hide the filters? Based on my test, if I hide a filter in Filter Pane, it will not appear on the visual. It shows "No filters applied" no matter I export data with current layout or export the summarized data.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @astano05
How did you hide the filters? Based on my test, if I hide a filter in Filter Pane, it will not appear on the visual. It shows "No filters applied" no matter I export data with current layout or export the summarized data.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
i think this is it. i have the entire filter pane hidden; not the individual applied filters.
"I have hidden filters that the end-user does not need to see" - you may want to rethink that. It will be better to apply these in Power Query instead.
Note that if you allow users to "Analyze in Excel" (as you should) then these hidden filters will be meaningless also.
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |