Getting issues while adding more dataset in analysis

Question & Answer
,
1

we are using amazon internal user (amazonbi), we are using approximately 35 dataset in our dashboard , we want to add 20 more dataset but we are not getting options to add in our analysis …tell me solution to add more dataset in analysis
analysis link https://us-east-1.quicksight.aws.amazon.com/sn/analyses/d2da27f4-e2c3-47fe-acb0-351d6c023677/sheets/82b645a6-7793-43f6-abf4-b0dc78365ab0
dashbord link : https://us-east-1.quicksight.aws.amazon.com/sn/dashboards/85448696-c073-4947-8979-ea494a8d1464

2

Hi @bhattshe

Here are the limits to how many datasets you can have in your analysis and sheets per analysis.

image
image962×360 37.3 KB

3

Please let me know if we can increase the limit of adding the dataset.

4

You can increase the visual limit but i don’t think so you can increase dataset limit.
The other way is you can join the different datasets into one if possible.

5

Hi @bhattshe,

First of all, welcome to the QuickSight Community!

Regarding your query, if I understand correctly, you’re asking about using 35 datasets in a single analysis?

If yes, it’s not recommended to use 35 datasets in a single analysis. Instead, you can use Athena or an RDBMS with custom SQL.

If no, could you please clarify your query further?

Thanks & Regards,
Biswajit Dash

6

hi @Biswajit_1993 so regarding my query i got the update that you had a limitation of 50 dataset in single analysis , so we created new analysis for addition dataset as we already exhausted this limit

1 Like
7

Hi @bhattshe,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

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

Thank you!

8

Hi @bhattshe,
Since we haven’t 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 and link this discussion for relevant information if needed.

Thank you!