Forum Discussion

ShrutiJ's avatar
ShrutiJ
Helper II
5 years ago

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 fe...
Need Help
ShrutiJ's avatar
ShrutiJ
Helper II
5 years ago

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.

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

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.