Forum Discussion
Power BI + Azure SQL Server row-based security
Is it possible with Power BI and Azure SQL Server database to use row-based security? I know it's possible with a SSAS model. We have a SQL Server database running on Azure, and we would like to ...
andre
Memorable Member
Memorable Memberwell, there are three things that I have to say about this:
- Power BI should have built-in rich security capability that permeates groups, datasets, reports dashboards and dataset attributes and calculations - unfortunately, it is not currently part of the service and we have not heard any comments from Microsoft on whether security will be built into Power BI
- I suggested here to make USERNAME() work in the service but it's not a good, robust solution, although it would allow for some options to secure data in the model by user. Again, no comments from Microsoft on that
- Unfortunately, your only option is to promote your Power Pivot models to Analysis Services. Even more unfortunate, your Desktop models cannot be promoted to Analysis Services in SQL 2014 because they are using the SQL 16 features and are not backwards compatible.
ashishrj
Power Participant
Power ParticipantHi andre I am trying to implement SSAS tabular row level security for SSAS in SQL Server 2014 but could not succeed. I was able to successfully implement the same using SSAS in SQL Server 2012. As you mentioned "Even more unfortunate, your Desktop models cannot be promoted to Analysis Services in SQL 2014 because they are using the SQL 16 features and are not backwards compatible". So how will I make row level security works for SQL 2014? Any reference link for your statement? or any alternative solution ? I am stuck with the same on a project and needs to apply row level security asap. Any help would be appreciated. Thanks in advance.