Hello I just want to understand even after creating partition. How can I join these datasets so data can be represented in single dashboard. Please help

Hi @deepa.singh - If your overall row count > 1billion, it will throw the error. I believe, you should perform some level of aggregation or filter and reduce number of rows and then bring the data to QS for reporting. Regards - Sanjeeb

Hi @deepa.singh how many rows are we talking about? BR

More than billion rows as of now

SPICE or Direct Query? Data source quotas - Amazon QuickSight Find out the quotas that affect Amazon QuickSight data sources.

Spice , I know the limit but if we create dataset for different region : the row limit is still maintained I want to know how to join those datasets so it can be displayed in one dashboard

[image] ROW_SIZE_LIMIT_EXCEEDED - what to do next? Question & Answer I can’t be the only person with more than 1 billion rows of data that’s not even that much. Does quicksight just not support users with this much data? This question has an answer to pull data in mu…

Hi @deepa.singh so you mean you have partitioned by e.g. year (one for 2023 and one for 2022) and want to join it into one dataset? BR

@ErikG - Please share an update here

But do you want to join or merge? Because join would create more columns and merge more rows.

Row limit issue

Q&A

deepa.singh March 14, 2024, 9:52am 7

This question has an answer to pull data in multiple set but not sure how to join them

Topic		Replies	Views
Union Datasets within dashboard Q&A data-source , quick-sight , dataset	3	578	June 8, 2023
ROW_SIZE_LIMIT_EXCEEDED - what to do next? Q&A data-source , error , quick-sight , dataset , qls-spice , Business-Intelligence-Engineer	6	1745	February 27, 2024
Visual type shifting between two datasets on basis of filter Q&A data-source , analysis , quick-sight , Business-Intelligence-Engineer	1	48	July 3, 2024
Quick Sight - Dataset join issue/Dataset size limitation - [High Priority Question] Q&A data-source , analysis , error , quick-sight , calculations	4	719	April 8, 2026
Huge datasets on quicksight Q&A quick-sight	2	1600	April 12, 2023

Row limit issue

Related topics