Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AndreaPRJ
Helper I
Helper I

Export only some data

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

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

1 REPLY 1
ibarrau
Super User
Super User

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.