Forum Discussion
Unable to export to csv file
- Anonymous2 years ago
Hi BrianD ,
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
- BrianD2 years agoRegular Visitor
Hi,
Is there a timeline for resolving this issue as we have a number of reports which have significant number of lines which we would require to be able to export to excel and currently we are unable to do so.
Thanks for flagging that this is a known issue.
- Sukhraj_Ghuman2 years agoRegular Visitor
I just found another workaround.
You can upload the report online and you can export the data from P.Bi online, with this method io could download all the rows.
Thanks- foodd2 years agoCommunity Champion
Yes, the Service can do this.
- Sukhraj_Ghuman2 years agoRegular Visitor
I tried to export with dax studio, but it trunc for 500 rows, its better but still dont enought.