Forum Discussion
PBI RSL - restrict all except
You will NEED to use a user or security group. It will have all possible users, to apply to the default role. This could be more extensive that the list of users that will have access to the report
Super UserOne option is you need to Embed this report in a web application. Your implementation should be Embedding reports for external customers
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-customer-app
With this approach the end users does not need to login to power bi if they want to access your report.
Coming the Row level security
In your web application, you might use javascript or any other language to generate embed token for the user who logged into the web application. While generating the embed token you need to pass the role name and the filter value. It will generate the token as per the values that you pass while sending the request for embed token. It will not verify whether the logged in user is added to the security role in power bi service.
Check out this blog to know more about generating embed token for the reports with RLS
https://learn.microsoft.com/en-us/power-bi/developer/embedded/cloud-rls#dynamic-security
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|