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
Anonymous
Not applicable

Data Export Truncated without Warning

When I export data from Power BI to Excel it automatically gets truncated but does not warn me. Also it doesn't seem to export 150k rows as the limit suggests. Is there at least a way I can configure Power BI to warn me that the data I am exporting is exceeding the maximum limit? Please don't link me to the documentation regasrding limits I have already read this.

1 ACCEPTED SOLUTION
Anand24
Super User
Super User

Hi @Anonymous ,

 

I guess you already know the export limit(30,000 row limit for data extractions to csv and a 150,000 row limit for data extractions to xlsx). 

Currently there doesn't seem to be a way/work-around to warn the users when exporting exceeds the limit. These have been submitted as ideas.

As @collinq said, you can copy data as a way around for now.

 

You can vote for the below 2 ideas so that these can be probably taken care of in future updates:

1. Exceed export Limit: https://ideas.powerbi.com/ideas/idea/?ideaid=9ce8bc4b-484e-4dba-b4e0-7cf49116c08f

2. Warn when exceeded: https://ideas.powerbi.com/ideas/idea/?ideaid=65524e4f-dcd9-4f49-bf70-493aea70df52 

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

View solution in original post

2 REPLIES 2
Anand24
Super User
Super User

Hi @Anonymous ,

 

I guess you already know the export limit(30,000 row limit for data extractions to csv and a 150,000 row limit for data extractions to xlsx). 

Currently there doesn't seem to be a way/work-around to warn the users when exporting exceeds the limit. These have been submitted as ideas.

As @collinq said, you can copy data as a way around for now.

 

You can vote for the below 2 ideas so that these can be probably taken care of in future updates:

1. Exceed export Limit: https://ideas.powerbi.com/ideas/idea/?ideaid=9ce8bc4b-484e-4dba-b4e0-7cf49116c08f

2. Warn when exceeded: https://ideas.powerbi.com/ideas/idea/?ideaid=65524e4f-dcd9-4f49-bf70-493aea70df52 

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

collinq
Super User
Super User

Hi @Anonymous ,

 

According to the documentation, Excel has a column width of 255 characters and a row height of 409 points.  Therefore, sometimes, the export will be truncated.  THere are also a number of items that are limited by available memory on the machine being used.  Also, depending on your configuration, Excel may be truncating the column width but you only have to expand it in the Excel column

 

As for the 150k limit, when you export you may need to select underlying data to get more of the rows you expect to export.  Also, there is a 10k limit when you copy instead of export, are you maybe doing it that way?

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




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