Azure SQL Database V12 + Row Level Security

[jldaley86]

Hi everyone! 🙂

We're in the process of turning our small scale PBI setup into something quite a bit larger so we can support a large number of users without having to develop individual reports.

With that being said, we have found a bit of information on implementing row level security within SSAS, however we're quite interested to understand how it could also work for Azure SQL Database V12.

Given it seems like its a new feature we would appreciate any help as we're struggling to find out:

a) whether row level security is possible (MS say yes, users tend to say no!)

b) if so, how PBI authenticates to Azure SQL (Azure AD?)

Thanks in advance 🙂

[ankitpatira]

@jldaley86 You can also consider now row level security in powerbi itself. so you can create roles in powerbi.com, add users to it and filter data for those roles. 

[jldaley86]

Hi Ankitpatira,

Thanks for your comment. Yep we've been playing with the new RLS feature in PBI, however unfortunately it appears the roles must be created and maintained through PBI rather than at the backend.

We tried storing the permissions for certain fields (e.g User A = "Australia" for country field) in the database and use DAX to lookup the value based on the user, however it doesn't seem like this is supported.