Will an excessive amount of columns hinder dashboard performance And max number of visuals in a sheet

Q&A
, ,
1

I am concerned that my dataset (currently in a wide structure (containing many columns)) will slow dashboard performance for my users.

  1. What is the max columns I can have in a dataset before dashboard performance starts to become affected?
  2. Also, what is the Max number of visuals I am able to have displayed in one sheet of my dashboard?
2

Hey @huda.h.yazgi ,
for 1. Data source quotas - Amazon Quick Sight here you have the quotas for the datasets.
for 2. Adding visuals to Amazon Quick Sight analyses - Amazon Quick Sight the number of visuals

Performance is kind of hard to answer. With visuals it depends how complicated are your calculations, which visuals do you want to use etc. Same for the dataset, do you use spice or direct query, how is the dataset build etc.

BR
Robert

2 Likes
3

Thank you for your response @robert.eibers . The datasets will be using SPICE and I worry If I continue to add columns to the dataset it will slow my performance. I plan on using the columns in calculated fields and parameters to all the user to select a combination of these columns.

4

@huda.h.yazgi ,

Checking in, are you still looking for any suggestions or recommendations or this topic is resolved ?.
If we do not hear back in the next 3 days, we will archive the question.

Kind regards,
Koushik

1 Like