Skip to main content
rameshp575128
Known Participant
February 17, 2025
Question

Limitations of export DSE to Excel smart service

  • February 17, 2025
  • 3 replies
  • 3 views

I am using export DSE to Excel smart service, but the output data is not the full data the Table is having.

I am having around 21k data in table where as the excel that was generated through the smart service is having only 20k rows.

Are there any limitations for smart service?

3 replies

Participating Frequently
February 17, 2025

Yes.We can Only Fetch 20k recorrs  and In Grid Also We have same limitation while donwloding the data from Grid

mathieud0001
Brainy
February 17, 2025

I think the limitation is more around the amount of rows that Excel can handle. (1,048,576 rows).

I was able to generate an excel file with 1M rows with no issues.

venkatrea696188
Inspiring
February 17, 2025

I agree with Mathieu's comment , It's more about the size and query time it took to get the data . Are you sure you don't have any filters on the file ??And is it getting first 20k rows??