Forum Discussion
Export functionality exports less rows in excel
I have a report with table visual which has ~80K records and published in a workspace. When I export the data of this visual, it exports ~28K records only although the limit is 150K. When I remove few columns and export the data agin, the number of records in the excel increases.
Is there a limitation on the number of columns while exporting or any limitation on the file size?
6 Replies
Hi ShrutiJ
Here are the limitations cited in this link
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Hi ShrutiJ
I am afraid to tell you that limitations for an excel sheet is not only the number of rows. The 150K rows is the maximum that Power Bi can export, the rest can be found here.
So I am guessing that your report is facing one of the limitation mentioned in the site and you will need to find out! Note that the Excel version that you are using can also apply some limitations.
Hi, ShrutiJ
According to your description, you said that “it exports ~28K records only although the limit is 150K.” But I found that the limitation is around 30K in the document, you can check this:
- The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-robertq-msft ,
I'm exporting it in an excel. Hence, expecting to have a limitation of 150K.
- "The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000."
As I mentioned, on reducing the number of columns the records increased, I could go upto 40K.
Not sure if there is some limitation here on the number of columns also. Need help to understand this.
Hi, ShrutiJ
Can the Excel specifications and limits document shared by aj1973 help you to find the true reason that limited you?
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
