Bug in report subscriptions? No RLS but getting an RLS error message...

[Anonymous]

I have a report with no Row Level Security, based on a model also with no RLS

Subscribing other users to it results in this error message saying the subscription "has RLS models"

Is this a bug or just an issue that means you can't subscribe anyone but yourself to any report...?

Here's the view of roles in the model (ie. empty)

[DVaught83]

I am still receiving errors on email subscription to users other than myself. Has there been any resolution or communication from Microsoft on this bug?

I believe I will start my own ticket today, but wanted to check here first...

Thank you!

[Anonymous · Accepted solution]

They said it's something to do with SSO and that they've fixed it

[DVaught83]

I too have a fully imported dataset with no RLS. I cannot subscribe anyone other than myself in the workspace or the app. Has anyone received a response back on a ticket to MS?

[Anonymous]

MS has confirmed it's a known bug related to Single Sign On (they think) and I have a call with them tomorrow. I don't think there's a solution yet.

[Anonymous]

MS just confirmed it's a bug - no solution yet

[Anonymous]

We are seeing exactly the same issue.  Our particular data set is 100 % imported data.  Creating a subscription to myself works.  Including another admin on the workspace fails, but that admin can create a subscription to himself with no problem.

This happens with subscriptions created either from the workspace or the app.

[v-easonf-msft]

Hi , @Anonymous 

What kind of data source connection mode   are you using?(Sqlserver datasets that are using DirectQuery?  )

As mentioned by document,for report email subscriptions, if the dataset uses RLS, you can create a subscription for yourself. You can't subscribe others to a report with row-level security (RLS) applied, except for paginated reports. You can subscribe others to a paginated report, using your security context. 

Please check the dataset security.

When rls is not used, you will see the following view on the service

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi @v-easonf-msft - thank you for taking the time to reply

There is no RLS applied in this case - this is a bug. Is there a known cause? E.g. recently we needed to set the language in everyone's account to English because another bug was being triggered by the language being "default".

Confirming this is the security information on the dataset in Service:

[v-easonf-msft]

Hi , @Anonymous 

No similar bugs  were found in the "Issue" Forum.

For the issue, I cannot reproduce it here.It is recommended to create a support ticket to investigate this issue.

https://powerbi.microsoft.com/en-us/support/ 

Best Regards,
Community Support Team _ Eason