Forum Discussion
Paginated reports subscription RLS not working
Hi Anonymous
There is an issue setting up a subscription to a RLS protected Paginated Report that you have identified, the Subscription is sent with your permissions, so the attached Report in your case will be blank. However the users also get the link to the Report which will be subject to RLS for them.
Perhaps it may be better to share the Report with the users then encourage them to set their own Subscriptions up for themselves, so they will get the correct Report.
However, the main problem is that without a PPU licence the users will not be able to view the Report shared with them. Any content on a PPU workspace can only be shared with other PPU licence holders.
see: Paginated reports in Power BI: FAQ - Power BI | Microsoft Learn
Hope this helps
Stuart
Hi Anonymous
There is an issue setting up a subscription to a RLS protected Paginated Report that you have identified, the Subscription is sent with your permissions, so the attached Report in your case will be blank. However the users also get the link to the Report which will be subject to RLS for them.
Perhaps it may be better to share the Report with the users then encourage them to set their own Subscriptions up for themselves, so they will get the correct Report.
However, the main problem is that without a PPU licence the users will not be able to view the Report shared with them. Any content on a PPU workspace can only be shared with other PPU licence holders.
see: Paginated reports in Power BI: FAQ - Power BI | Microsoft Learn
Hope this helps
Stuart
Hello Burningsuit ,
Thank you for quick answer. So basically everyone needs PPU licensing? Is there any kind of way to work around this using for example power automate flows? Or is it possible to upload paginated report to a pro license workspace and then everyone can subscribe it to themselves?
Hi Anonymous
No, there's no real workaround, especially not if you've implemented RLS. Without RLS you can do things like send the Subscription to yourself, then use Outlook rules to forward the email on the other users, but as you've found with RLS you are subject to your permissions, so the subscription recipients only get what you can see.
If you have a small number of users (<500) it's cheaper to get them all a PPU licence, otherwise if you have a large number of users, then get a "Premium Capacity" licence this allows sharing with "Free" licence users.
Hope this helps
Stuart