How to Export the More than 1,50,000 lakhs rows in to Excel from Power BI Table visual from visual

[Koritala]

Hi,

How to Export the More than 1,50,000 lakhs rows in to Excel from Power BI Table visual from visual.

My report is having detail level data and have rows almost morethan a million.

Can any one suggest, how to achive the same in power bi?

Thanks,

Sri

[Nasif_Azam · Accepted solution]

Hey @Koritala ,

Exporting more than 1.5 million rows from a Power BI table visual to Excel directly from the visual has some important limitations and workarounds you should know.

Power BI Export Limitations

Data with current layout              -->    150,000 rows
Underlying data (Pro users)         -->    150,000 rows
Underlying data (Premium)         -->    30,000,000 rows
CSV Export from Service             -->    30,000 rows

These are default service limitations and cannot be bypassed through the visual export options unless you switch to a Premium workspace and use paginated reports.

Workarounds

1. Use Paginated Reports (Power BI Report Builder)

• Paginated reports can export millions of rows to Excel.

• Steps:

  1. Install Power BI Report Builder.

  2. Connect to your dataset.

  3. Design a table report similar to your Power BI visual.

  4. Export to Excel or schedule delivery.

• Requires Power BI Premium capacity.

2. Use DAX Studio to Export Data

• DAX Studio can export results of DAX queries to Excel or CSV.

• Steps:

  1. Open your PBIX file in Power BI Desktop.

  2. Open DAX Studio.

  3. Connect to the data model.

  4. Write a DAX query that returns your table data.

  5. Export results to CSV or Excel using the "Export Data" option.

3. Use Analyze in Excel (With Pivot Limitations)

• "Analyze in Excel" connects the Power BI model to Excel.

• However, pivot tables aren't optimized for millions of rows, and it may slow down.

• Use Power Query in Excel instead for performance.

4. Push Data to Dataflow or Azure SQL / Lakehouse

• If you're working in Power BI Premium or Fabric, use:

  • A Dataflow Gen2, or

  • Export the dataset to a Lakehouse / Azure SQL table.

• Then connect Excel to that source and export data.

5. Split Export by Filters

• Apply filters or slicers (e.g., by date, region, category).

• Export in batches of ≤150,000 rows.

• Automate using Power Automate Desktop or Python (if allowed).

Exporting 1.5 million rows directly from visual into Excel in one shot from a Pro workspace is not possible. Excel will truncate beyond 150,000 rows.

For Detailed Information:

Export data from a Power BI visualization

Export Power BI paginated reports

Exporting more than 150,000 rows from Power BI report

Export Data to Excel exceeds munity.fabric.microsoft.com

How to quickly export data from Power BI Desktop with DAX Studio

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

[ribisht17]

Hi @Koritala 

Please check

Export large amount of data from Power BI desktop visuals

Performance analyzer pane to export all data of a visual

Regards,

Ritesh

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data Projects - YouTube

[Koritala]

Hi, I need to export table visual data from power bi service not from desktop