Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Service download line limit increased?



I just noticed the download limit for "Summarized data" is 500,000 lines. Please does anyone know if this used to be lower? Did it used to be 150,000 lines like the "Data with current layout" option?




Thank you,




Super User
Super User

Hi @PowerWhy ,
Excel exportable limit is still 150,000 rows. This would be the 2nd option in dropdown of file format.
500,000 rows is the max limit of no. of rows for connecting an excel live to your dataset/report. This is a new option provided by Power BI. You can connect your excel live to Power BI dataset and play around in excel with this option.


Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!


Skilled Sharer
Skilled Sharer

It's still an option for 150k on the drop down, the 500k is a completely different type of export and is confusingly now shown as the default.


It has it's advantages in some select scenarios, but most users will probably want the previously default option (in the drop down)


150k is a flat file

500k is a live connected table and may or may not work in all cases

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors