Quicksight Report not getting generated inspite the schedule being active

Question & Answer
, , ,
1

I have setup a daily schedule to generate a report from a QS dashboard. The report is not getting generated every day as per schedule. However, we can see that the data has been updated in the back end QS analysis file. Is there any RC hypothesis that explains such occurrences?

2

Hi @patrowww and Welcome to the QuickSight Community!

That’s interesting, would you be able to share screenshots of the schedule information you created for this so that we can see what might be causing this?

Thank you!

3

Screenshot 2024-06-13 at 11.45.12 AM
Screenshot 2024-06-13 at 11.45.12 AM223×842 29.2 KB

Here is the screenshot of the settings of the schedule

4

Hi @patrowww,
Thank you for sharing, this is very interesting. A couple small things that you could possibly check:

  • Confirm that the Email is correct in the Email recipients section
  • Is your QuickSight account attached to your Email?
  • Are there any RLS restrictions on the datasets that might keep it from sending?
  • Is the dashboard you’re scheduling for send shared with the user the Email is being sent to?
  • Did it possibly show up in your spam/junk folder?

I would start by checking those things and if it’s still not working, I would suggest deleting the schedule and trying to create a new one. If that is still not working, you can submit a support ticket.

One last thing to note, if it’s important to receive by a specific time each day, the time you set up in the schedule will be the time that it starts the process of sending. This may take some time depending on the size of your dashboard. So I would suggest setting up a few minutes before your desired time as well if that’s the case.

Let me know if you have any additional questions.

Thank you!

5

Hi @patrowww,
It’s been awhile since we last heard from you. Checking in to see if you were able to try out Duncan’s suggestions for troubleshooting. If any of them worked for your case, feel free to share with the community what worked.

If we do not hear back within the next 3 business days, I’ll go ahead and archive this topic.

Thank you!

6

Hi Duncan,

The issue is email gets generated on some days and not on others. So all the above raised questions are not valid in this scenario.

However, i did reach out to the Quicksight Push team and got to know that when there is a overlap between data refresh and report schedule, the report schedule will fail because an incomplete report might be generated.

1 Like
7

Hi @patrowww,
Glad you were able to get additional context on this category, thank you for sharing!