Forum Discussion
Export to CSV too large?
Hi all,
2023-09-18 update:
The deployment of the fix has begun and has been completed in some areas.
----------------------------------------------------------------------------------------------------------------------------
This is a known issue.
Power BI known issues - Power BI | Microsoft Learn
Solved: Exporting to CSV from Power BI Service - Microsoft Fabric CommunityThe product team is currently working on fixing this issue.
For the desktop a possible mitigation is to use the older version of the desktop.
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.
I'll update here with any new news.Best Regards,
Gao
Community Support TeamIf 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
Super UserJ4kesDB Hello,
You can use .xlsx extension for export your data as .csv file have limit of 30000 row only.
or
Also try below things.
Reduce the size of an Excel workbook to view it in Power BI - Power BI | Microsoft Learn
Thanks
Harish M
Hi HarishKM
Thank you, will try the .xlsx option, however I only have 700 rows (Appended), so its well below the 30 000 max.
The core work sheet is also 1.9MB and the last exported sheet was last week friday and it was 352kb - since then no rows were added, only cell content changed in the source workbook.
I can view the work book in Power BI, I am unable to export
Then I get the following message
I also did a check, it is happening on all of my reports. I have 9 Power BI Reports (different files) with different source files and each of them gives me the same message when trying to export.
Kind Regards
J