top of page
Writer's pictureBrunner_BI

Exporting data from Power BI Desktop without limits

We all know the export limits of Power BI and sometime they might be a problem. Generally we do not recommend exporting data from Power BI to Excel. If you really need to do it however, this blog post will help you get around the internal export limits.


According to the official documentation:

The maximum number of rows that Power BI can export to a .csv file is 30,000 - to an .xlsx file 150,000.


Using DAX Studio we can get around these limits.


1) Open DAX Studio

2) Connect to your model

3) Copy this code into the main window

// My Query
EVALUATE( myTable )

4) Go to Output -> Static (Excel) for .xlsx and File (Standard) for .csv

5) Click on Run or press F5



The .xlsx file (1M rows) ended up having 45MB (remember, xlsx files are compressed)

It took about 30 seconds and my data was cut off since I had more than 1M rows in my fact table.


The .csv export with all ~15M rows had 1.3GB (uncompressed file) and took 3.5 minutes


8,437 views6 comments

6 Comments


Ali Biktash
Ali Biktash
Mar 16, 2023

how I use the csv to export the 15 Million row without get this msg "This data set is too large for excel grid, if you save this workbook you will lose data that wasn't loaded"


Like
Ali Biktash
Ali Biktash
Mar 16, 2023
Replying to

I got this error when I used standard


Like

kshoemaker
Feb 15, 2023

Do you have to run this process every time you update your model? and Do you have to run this process every time you create a new model?

Like
Brunner_BI
Brunner_BI
Feb 15, 2023
Replying to

Every time you want to create an export you will have to run this. I hope this answers your question!

Like
bottom of page