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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
herman_ng
Regular Visitor

data exceeds Limit

Hello, 
anybody can help how to figured out what is the problem ?
as I l know the limit for exporting query table to .csv file is 30,000 rows.
but i currently got issue ( before no issue until today)  , my data only 1800 rows .. but cannot export out to .csv file.
the error message :

Data exceeds the limit


anybody can help ? 

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

Hi @herman_ng ,

PG is starting to work on the fix and will release.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

15 REPLIES 15
pradeep_kare12
Resolver I
Resolver I

 

Look for any error messages or notifications that might provide specific information about what went wrong.
Ensure that your data is loaded correctly in Power BI. If there are any errors during the data loading process, it may prevent you from exporting the data. Check the "Data" view in Power BI Desktop to verify that your data is loaded without errors.
Make sure that the data types of the columns you're trying to export are compatible with the CSV export. For example, if you have columns with complex data types like images or objects, they might not export properly to CSV.
Special characters- Ensure that your data doesn't contain any problematic characters.
Verify that you have the necessary permissions to write to the directory where you're trying to save the CSV file. Also, make sure the file path you specify is correct and that the directory is not read-only.
When exporting, ensure you are using the correct export options. For instance, make sure you are not limiting the export to a specific selection or filter in your report that might exclude data.

HI all , thanks for all sugestion and reply.
looks like the september Power bi Desktop update have  fix the issues.
for others that have issue with exporting big data , my suggestion uses dax studio , create the query that you need into the new table and export it via dax studio will be very helpfull too...

 

thanks all.

v-rongtiep-msft
Community Support
Community Support

Hi @herman_ng ,

This has now been fixed, please use the latest version of desktop

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

My version has a different number, do you have idea why?
I use the app version from, Microsoft Store 

Version: 2.121.942.0 64-bit (September 2023)

nathanymiguel22_1-1695846078408.png

 

 

Yours is a small amount ahead of the install from the Store I mentioned earlier.  Perhaps it is a release wave that is occurring.   Important point, does the data export look fixed to you?

It appears to be fixed on the version of Power BI Desktop from the Microsoft Store.  Successfully exported 2134 rows as CSV.   Screenshots below:

 

foodd_0-1695810579657.png

 

foodd_1-1695810579646.png

foodd_3-1695810664299.png

 

v-rongtiep-msft
Community Support
Community Support

Hi @herman_ng ,

PG is starting to work on the fix and will release.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-rongtiep-msft
Community Support
Community Support

Hi @herman_ng ,

This issue has been resolved. You can verify it. If you have any questions, please leave a message. Thank you for your empathy.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

The users from my company are facing the data limit error when exporting to EXCEL

You mean we can now export more than 300? I tried, same issue arise

Hi @herman_ng ,

Workaround tested: Exporting the data to CSV from the July version of PBI Desktop.

Or In the service, the issue is specific to exporting to Csv format. A possible mitigation is to export to excel and the convert the file to csv.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-rongtiep-msft
Community Support
Community Support

Hi @herman_ng ,

As @foodd  said, this is a known issue. And we have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it. 

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

foodd
Super User
Super User

This is a known issue.

 

Issue ID:  498

Title:  Export to CSV file truncated at 300 rows

Description: When you select Export data on a tabular visual's options menu and choose to export to a CSV file, the resulting downloaded file is truncated to 300 rows, rather than showing all the available rows.

Status:  Active

Reference URL:  https://learn.microsoft.com/en-us/power-bi/troubleshoot/known-issues/known-issue-498-export-csv-file...

 

Additional workaround:  Use DAX Studio to export data from selected Visual to CSV or Excel.

how to use dax studio?

john_c
Regular Visitor

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors