Forum Discussion
Solution SpecialistRLS not applied on PDF Attachments to Subscribed Users
Community SupportHi Mohammad_Refaei,
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.
For more information, please refer:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Solution SpecialistThank you v-xulin-mstf for your response. I am Power BI admin and I was able to subscribe other users to the report.
Though I am a Power BI fan, I have to admit that it is a very frustrating experience to me which made no sense at all.
RLS is applied but all subscribed users get the full report with complete negligence of the security roles.
I contacted Microsoft Support and the support level was far below expectations. They were responsive, but almost had no clue what the issue is.
I think Power BI is messing up with licensing options without clear differentiation between what's being offered for each license. Found that Premium Capacity is probably quite expensive, so introduced the so called Premium Per User licensing and tailored some deformed functionalities.
It is beyond my comprehension to define security roles while when I share the report, guess what? security is totally ignored!
- v-xulin-mstf
Hi Mohammad_Refaei,
We are sorry for the unpleasant experience you had.
Please try subscribing using paged reports，unlike subscriptions for dashboards or Power BI reports, your subscription contains an attachment of the entire report output and it also supports the following attachment types, such as PDF, PPTX, etc. Even if the dataset uses row-level security (RLS), you still can create subscriptions for yourself and others. Those subscriptions will run using your security context.
For more information, please see: Paginated reports in the Power BI service
Hope it helps.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
- Mohammad_Refaei
Thank you v-xulin-mstf ... I will give it a try.
- Mohammad_Refaei
Unfortunately I am having the same behaviour.
Security roles are ignored when I subscribe other users.
- v-xulin-mstf
Hi Mohammad_Refaei,
Sorry that you are still plagued by this issue.
Please summit a support ticket for help.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!