cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovetteabejuela Established Member
Established Member

Export Data - Data Exceeds the Limit

Hi,

 

I suspect this comes with the November update. When I try to do an Export Data from a Matrix or Table I am now getting a Data Exceeds the Limit error, I used to be able to Export data with a wide date range but after the update it's now giving me that even if I select a single date to export.

 

What's going on?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Export Data - Data Exceeds the Limit

Hey,

 

the documentation states that there is a limit of rows that can be exportet to csv, this limit is 30000 rows.

 

Using the target format xlsx this limit is 150k rows, the export to xlsx option is available in Power BI Service.

 

These limits are described here:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data

 

Please don't ask me why such a limit exists :-) I'm just the messenger

 

Regards

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

View solution in original post

23 REPLIES 23
Moderator v-yuezhe-msft
Moderator

Re: Export Data - Data Exceeds the Limit

@ovetteabejuela,

I can reproduce your issue in November update. Based on my test, the message will throw when you export >=500 rows data. When your visual contains >=500 rows data, as long as you click "Continue" button, the data will be exported in CSV properly.

Besides, I will report this issue internally and post back once I get any updates.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ovetteabejuela Established Member
Established Member

Re: Export Data - Data Exceeds the Limit

Thank you for looking and kindly post back. Okay so the "Continue" option will not truncate anything?

 

As of now I recreated everything in Excel PowerQuery just for that portion where we need the data exported in CSV.

Moderator v-yuezhe-msft
Moderator

Re: Export Data - Data Exceeds the Limit

@ovetteabejuela

When I test with 10000 rows and use Export data option, the data are not truncated, but for the specific limit, we still wait for PG's response.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
alex139 Frequent Visitor
Frequent Visitor

Re: Export Data - Data Exceeds the Limit

@ovetteabejuela

As a temporary workaround, you can try reverting to the October version or you can ignore the warning for datasets smaller than 30k rows.

ovetteabejuela Established Member
Established Member

Re: Export Data - Data Exceeds the Limit

What more I have observed is that if it reaches a certain number of rows, it removes duplicate columns which I intentionally placed but if it's less rows it just leaves duplicate columns alone.

 

So probably I could say it does not truncate by rows(to a certain number maybe 30K or 100K) but it certainly does remove duplicate columns.

alex139 Frequent Visitor
Frequent Visitor

Re: Export Data - Data Exceeds the Limit

@ovetteabejuela

I will test this tomorrow morning. If you have any datasets you have used in your tests please share. Thank you.

Moderator v-yuezhe-msft
Moderator

Re: Export Data - Data Exceeds the Limit

@ovetteabejuela,

The fix of this issue will be released on January.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ovetteabejuela Established Member
Established Member

Re: Export Data - Data Exceeds the Limit

@v-yuezhe-msft,

 

Looking forward for the fix, thank you.

Highlighted
AfriKan Frequent Visitor
Frequent Visitor

Re: Export Data - Data Exceeds the Limit

Thanks for raising this issue.  I have the same problem and look forward to the Jan '18 solution

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 45 members 1,012 guests
Please welcome our newest community members: