Forum Discussion
Subscriptions not being sent
It seems that the issue were due to performance overload as one of the tables includes images.
After removing the images the subscription works just fine.
Super UserEven though you are an admin, subscriptions are sent based on the security context of the user setting them up. If RLS is applied in any way, it might be affecting Report2 differently than Report1.
Since Report1 has a filter applied (limiting to three Sales Person Codes), it might be working because it aligns with the RLS settings. Report2 removes the filter, meaning it tries to show all data, but RLS might still be restricting what the subscription service can access, causing it to fail.
If the dataset enforces RLS at the data model level, even as an admin, subscriptions might not bypass it in a live connection. Check if the RLS rule on "Sales Person Code" is affecting Report2 in a way that blocks subscription emails from being sent.
Please mark this post as solution if it helps you. Appreciate Kudos.
Thanks for quick answer!
If I apply the same three codes in the Sales Person Code filter on Report2, the subscription email works.
However, I would like to be able to create lots of subscriptions moving forward - but this is not working 😞