Forum Discussion

mathiasbj's avatar
mathiasbj
Frequent Visitor
1 year ago
Solved

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). ...
Need Help
  • mathiasbj's avatar
    mathiasbj
    1 year ago

    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.

mathiasbj's avatar
mathiasbj
Frequent Visitor
1 year ago

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 😞

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

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.

  • mathiasbj's avatar
    mathiasbj
    Frequent Visitor
    1 year ago

    Thanks for super quick response!
    What exactly do you mean by this "... and configure the subscription or dataset access accordingly".
    As I wrote before, I have already tried to make an unrestricted role called FullAccess. How do I add this to the subscription?

    Actually, I also tried to remove all the RLS groups from the dataset - republish it to service - but the subscription still didn't work. If I then applied the Sales Person Code filter it worked. So somehow it seems that it still tried to fetch the RLS eventhough it has been deleted. That is very strange and Im not sure what the issue can be?

    • rohit1991's avatar
      rohit1991
      Icon for Super User rankSuper User
      1 year ago

      Hi mathiasbj

       

      In most cases, it’s related to how Row-Level Security (RLS) is set up. Power BI subscriptions won’t send if the report renders blank under the user’s security context and RLS can sometimes filter out all data for that user, especially if you're using something like a "Sales Person Code" to limit access.

       

      In your case, since the page without RLS works fine and others don’t, that’s a strong indicator RLS is blocking the visuals from rendering which then stops the subscription from sending.

       

      A couple of things worth trying:

      • Temporarily remove or relax the RLS to see if subscriptions go through just as a test.

      • Double-check if the users you're testing with are definitely mapped correctly in the RLS table.

      • Also, make sure there aren't large visuals (like heavy tables or images) that might slow things down, though RLS sounds like the main issue here.

       

      • mathiasbj's avatar
        mathiasbj
        Frequent Visitor
        1 year ago

        Thanks for answering!

        I tried to create a copy of the PBIX file, place it in a new workspace, remove all RLS groups, republish and make create subscription, but still nothing is being sent.

        I guess its data related then. Maybe due to the relations between tables?