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.
Good morning to all.
Is it possible to allow a user to export only some data instead of all?
I know the simplest solution would obviously be to create new ad hoc reports with active "fixed" filters, but I still wanted to understand if there is such a feature...
Thnaks in advance
Regards
Solved! Go to Solution.
Hi. The export option will always export all it can. The way to reduce rows will be filtering. If you want them to export less rows you can ask them to filter before export, add a hidden filter (or filter pane) or even RLS.
Another option you can consider is that inside the PowerBi Desktop settings or the Power Bi Service Report Settings you can configure the type of the export:
- Summarized data and data with current layout
- Summarized data, data with current layout and underlying data
- None
I hope that helps,
Happy to help!
Hi. The export option will always export all it can. The way to reduce rows will be filtering. If you want them to export less rows you can ask them to filter before export, add a hidden filter (or filter pane) or even RLS.
Another option you can consider is that inside the PowerBi Desktop settings or the Power Bi Service Report Settings you can configure the type of the export:
- Summarized data and data with current layout
- Summarized data, data with current layout and underlying data
- None
I hope that helps,
Happy to help!
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.