How to export more than 30,000 rows?

[snb778]

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,

[Brunner_BI]

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

[PijushRoy]

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]

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-d...

Can you install external tools? @snb778 

[PijushRoy]

Hi @snb778 

Please use flows