How to incorporate using Azure SQL RLS Security Policy framework with PowerBI RLS

Anonymous — Mon, 22 Jun 2020 15:21:32 GMT

To begin with, we already have a RLS applied to our database using Security Policy. Assuming we dont want to change that as it's doing fine for our other reporting solutions.

With POWER BI, we plan to use App Own Data approach to embed PBI Reports in our application. This approach does not pass through any user credentials but allows application to specify username at the time of generating embed token etc. which is all good and DAX expressions can be used to filter data out. However since PBI does not pass the username to the Database, the RLS Security Predicate filters forbid access to data. So unless we remove the RLS from Database, we won't get the data in PBI report.

Is there a bit I am missing here that could make them work together? Or that is how things are designed and the only way is to remove RLS from database with App own data approach.

topic How to incorporate using Azure SQL RLS Security Policy framework with PowerBI RLS in Developer

How to incorporate using Azure SQL RLS Security Policy framework with PowerBI RLS