Scenario Only Processes 1M Rows Despite Full Dataset Being 108M Rows – Any Guidance?

Question & Answer
, ,
1

Hi everyone,

I’m currently exploring the use case of Amazon QuickSight Scenario for our business. Our full dataset has around 108 million rows, and it is successfully imported into SPICE, as confirmed by the dataset import status (screenshot attached — 108,551,924 rows imported, 100% success).

To test how Scenario interacts with our dataset, I asked it a basic question:
“How many rows in total in our dataset?”
However, Scenario’s response indicated the dataset only contains 1,000,000 rows, which doesn’t align with the actual dataset size.

I’ve attached screenshots showing:

  1. Scenario’s response (1M rows).
  2. SPICE import status (108M+ rows, 117.1 GB).

My questions:

  • Does anyone know why Scenario is only seeing 1M rows?
  • Is there a configuration or setting required to ensure Scenario accesses and processes the entire dataset?
  • Is this a limitation or default sampling behavior of Scenario?

Any insights or guidance would be greatly appreciated!

Thank you in advance for your help — and have a great day!

image
image950×309 11.8 KB

image
image623×233 8.65 KB

1 Like
2

Hello @weilingp

When you ask Q “How many rows are in the dataset?”, it responds based on the 1 million‑row snapshot available to it—not the full 108 million in SPICE.

This is not a bug, but intended functionality: Q provides natural‑language insights on a sample or preview to keep response time fast and manageable.

Some supporting documentations -
According to this documentation, each data source added to a scenario is limited to at most 1 million rows in its previewed or snapshot form - Working with data in an Amazon QuickSight scenario - Amazon QuickSight?
Scenario Analysis Amazon Q in QuickSight | Cloudelligent

Please let me know if this helps

Thank you,
Shravya

3

Hi @weilingp,
It’s been awhile since we last heard from you on this thread; did you have any additional questions or did the solution provided above assist you?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

4

Hi @weilingp,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!