nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Warn users of 25k row limit when exporting to Excel (xlsx)

Patrick Lynch

The preview feature exporting to Excel (xlsx) format has recently been implemented as a general access feature. While in most instances this makes exporting data from dashboards much smoother, there is a 25,000 row limit that may affect certain users attempting to conduct analysis off exported data.

Alternatively, remove row limits when exporting to Excel (xlsx).

Find more posts tagged with

Excel

Export

Exporting

Needs Votes

Status: Needs Votes

Comments

Zach Jenkins

Agree. Users will export believing they have the complete data and not realize that it was only a partial export. Would prefer that the export fail if the user attempts to export more than 25k rows in excel or at least have a popup of some sort that warns them of the row limit

Juan Hurtado

I agree with the comment above. A popup for the very least appear stating that all data did not get extracted via xlsm. This will lead the user to believe that have the data they need.

Avinash Krishnaram-Oracle

Hello,

Limits have been increased for export to excel based on OCPU sizing. Refer to the documentation. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/what-sizing-options-are-available-you.html
Notifying users when export has reached its limit is a request in the backlog, not prioritized. There are several enhancements we are working on excel that takes priority over this ask.

Thanks,

Avinash