Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerWhy
Helper III
Helper III

Service download line limit increased?

Hi,

 

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?

 

PowerWhy_0-1679590543841.png

 

Thank you,

 

PW

 

2 REPLIES 2
Anand24
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.

PBI_SuperUser_Rank@1x.png  

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 !!!
LinkedIn

 

cassidy
Power Participant
Power Participant

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)
https://powerbi.microsoft.com/en-us/blog/announcing-connected-excel-tables-from-power-bi/

 


150k is a flat file

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors