filter with top n - does it limit data export or only visual ?

Hi, ruisadias ,

 

If i add a filter on details with top n ( lets say top 10k rows) , when user exports the data will it only export the top 10k ? or is this filter only for the visual and all data will be exported ? 

 

Only the data filtered by the filter is exported, not all of it. Secondly, the maximum limit for exporting CSV data with Power BI is 30,000 lines.
If you publish to service then export , you could export 150000lines.

 

• Go to app.powerbi.com and choose a report you have access to
  Click on “…” at the top right of the desired visual, then click the “Export data” button
  
  https://www.upslide.net/en/how-to-export-power-bi-to-excel/
• or you could right click, then copy table to excel.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-service#limitations-and-considerations

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.