Getting error while uploading dataset via API for calculated columns exceeding 256 members

Question & Answer
, ,
1

I am using API to upload my dataset json on quicksight and I am getting an error that members of calculated columns should not exceed 256, how can I encounter this issue and Is there any solution to upload all my calculated columns on single dataset.

2

Hi @Aditjain20

Welcome to the QuickSight community!

QuickSight enforces a hard limit of 500 calculated fields per analysis and 200 per dataset.

Simple workaround – Use analysis-level calculations: Move some calculations from the dataset level to the analysis level, which allows a higher limit of 500.

Please refer to the following documentation this might be helpful for you.

3

Hi @Aditjain20

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @Xclipse
Thank you for your response, it helped me a lot and my query also got resolved.

Thank you!