Forum Discussion

New Member

2 years ago

How to export more than 30,000 rows?

Hello, I have a table I created with 180,000 rows, how can I export past the 30K limit? Is there a "more beginnier" way vs creating a flow? Thanks,

Icon for Impactful Individual rank

Impactful Individual

2 years ago

https://www.brunner.bi/post/exporting-data-from-power-bi-desktop-without-limits-1

PijushRoy
Community Champion
2 years ago
Hi Brunner_BI

End users can't use Dax Studio to get export.
Power Automate with file creation or SharePoint list export can solve the question.
- Brunner_BI
  Impactful Individual
  2 years ago
  So first of all there is no mention of "end users" in the question.
  Also, in the Power BI Service, the limit to export is actually 150,000 but then you can Excel file.
  https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop#considerations-and-limitations
  
  Can you install external tools? snb778

Related content