How to export large tables to csv?

[JackFrench]

I have numerous dashboards in which my customer wants to be able to export them into a csv, to later load into Excel. Depending on their filters, the table can be up to 2 million rows. They claim they need all rows for reporting... My question is how can they export the table in Power BI Service as a csv, past the 150,000 row limit? Is there a way where I can link the Power BI semantic model table visual to the  data model within an Excel workbook? Looking for a solution for either. As long as they can export the table containing up to 2 million rows into a csv or straight into the data model/power query editor of an Excel workbook they will be happy. 

[v-sgandrathi · Accepted solution]

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.

[GilbertQ]

Hi @JackFrench 

Unfortunately, as it stands today, there are limits in terms of exporting data out of the power BI service, the highest you can do is 500,000 rows with a lot of connection. What you could then do is use that and put in a date filter so that they could then filter it by dates, which would then allow them to get the 2 million rows over multiple dates.