Forum Discussion
Subscriptions not being sent
Hi
I have a report (live connection) with two pages and would like to set up subscriptions.
It works completely fine for one of the pages (let's call it Report1), but not for the other (Report2). The email is simply not being sent.
I am admin of the datamodel and thus RLS should automatically be bypassed.
I have one RLS which filters on "Sales Person Code". Report1 has a filter on Sales Person Code where it filters on three codes.
In Report2 this filter is removed = showing all Sales Person Codes.
How come that the subscription is not working when no filter is applied to Sales Person Code and I'm admin?
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.
10 Replies
Even 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 😞
Hi mathiasbj
This is a subtle but common issue when using RLS with subscriptions. Even though you're an admin, Power BI still enforces RLS when generating reports for subscriptions it doesn’t automatically bypass it.
In your case, Report1 applies the RLS filter on "Sales Person Code", so the report stays within the allowed scope and works fine. But for Report2, removing that filter causes the report to try and show data for all sales people. If the RLS role restricts access beyond a certain scope, Power BI blocks the report from rendering fully, and the subscription fails silently.
To fix this, you can either:
-
Adjust the RLS role to allow broader access for subscription scenarios, or
-
Create a separate version of the report without RLS (if appropriate), just for subscriptions.
Thanks for great answer!
I tried to create a RLS group (called FullAccess) and added my own admin user to this group. Shouldn't this work then? It doesnt 😞Hi mathiasbj
Yeah, it’s a common catch! Even if you're an admin or created the report, subscriptions still run under the RLS rules defined in the dataset not your user permissions in the workspace.
So just adding yourself to a role like "FullAccess" doesn’t automatically bypass anything unless that role is set up to actually ignore filters like the "Sales Person Code". If that role still filters anything, it’ll impact the subscription.
If Report2 is failing because it's trying to show all sales codes, Power BI might be blocking it due to how RLS is applied. A quick fix would be to create a role that doesn’t apply any filters at all basically an “Unrestricted” role and use that specifically for subscriptions.
If security isn’t a concern, another option is to create a copy of the dataset without RLS just for reports that need to be emailed out.
-
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.Hi mathiasbj
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
