How to export large tables to csv?

Hi JackFrench,

Thank you for reaching out to Microsoft Fabric Community Forum.

You can load the full table data into Excel beyond the typical row limit by connecting directly to the Power BI Dataset (Semantic Model). To start, open Excel and navigate to Data--Get Data--From Power Platform--From Power BI (Microsoft). Sign in using the same account associated with your Power BI Service. From the list of available datasets, select the one linked to your Power BI report. Choose Transform Data to open the dataset in Power Query. In Power Query, select the desired table, apply any filters as needed, and then click Close & Load to load the data into Excel. If you prefer to export the data later as a CSV, you can select Close & Load To… Connection only. This method allows you to import large volumes of data, potentially millions of rows, into Excel or Power Query, constrained only by your system’s memory capacity.

Below are the Solved related thread links you can refer to:
Solved: Unable to export more than 300 rows to Power BI De... - Microsoft Fabric Community
Solved: How to export more than 150000 rows from Power BI ... - Microsoft Fabric Community

Below is the official Microsoft document Link for your reference:
Export data from a Power BI visualization - Power BI | Microsoft Learn

I hope my suggestions provided valuable insights. If you have any further questions, don’t hesitate to ask in a follow-up message.
If this post helped, please mark it as "Accept as Solution" so others can benefit as well.

Best regards,
Sahasra.