Quicksight need access to both, the Athena query results bucket and the S3 bucket which actually stores your data files that you are trying to visualize in Quicksight. Please make sure you give access to both in Manage QuickSight > Security & Permissions > QuickSight access to AWS services > Manage > Pick all S3 buckets
Kristin, No it did not. What max suggested is repetition of what I already described in the original post. I even deleted my quicksight account and recreated & followed all the permission guidance along with check , uncheck procedures.
I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!