Data exceeds the limit

[abi21gail]

Hi! Few days ago im having issues when it comes to exporting data in the BI. Please suggest any solutions

[foodd · Accepted solution]

Look to this post:  

Re: Unable to export to csv file - Microsoft Fabric Community

[Anonymous · Accepted solution]

Hi all，

Update:
This is a new issue and the Product Group is working to get this fixed.

Workaround:

There is an option to roll back the desktop version to mitigate this issue, or use the Export Data on PBI Service to process the data.

--------------------------------------------------------------------------------------------
Yes, this is a known issue. 
The deployment of the fix has begun and has been completed in some areas.
Please try again and let me know if you have any issues.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

Same here, but exporting to EXCEL

[foodd]

What is your question? What have you tried and where are you stuck?

[Anonymous]

What the user abi21gail shared in the name/description of this thread

"Data exceed the limit" error when exporting less than the limit 

[foodd]

You mentioned exporting as Excel as an issue.  Is the issue you are having exporting a Power BI Desktop Visual to a .CSV (visuals export as .CSV not .XLSX)?  This is a known Issue 498 and is still ACTIVE.

[Anonymous]

The users made a mistake, they are facing the issue 498. Thanks

[foodd]

No worries.

[foodd]

This is a known issue and is Tagged as ACTIVE.

Issue ID:  498

Date:  September 7, 2023

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.

[abi21gail]

how to use the dax studio?

[foodd · Accepted solution]

Look to this post:  

Re: Unable to export to csv file - Microsoft Fabric Community

[abi21gail]

Don't you have a simpler process? As I'm gonna do this daily.

[foodd]

Until Issue 498 is resolved, the option that Microsoft has recommended, as well as using DAX Studio as an External Tool are workable options.   Try it out, this is very quick and painless.    If you are exporting the same visuals day after day, save the query from DAX Studio and run the export as necessary.

[Anonymous]

Same issue here. Trying to export csv file with 478 rows and i get the error of exceedind limit of 30.000 and the exported file is just 300 rows.