Status:
Needs Votes
Leverage SQL Server 2016 Row-Level Security for Power BI Desktop published reports/datasets
As SQL Server 2016 now supports Row-Level Security, we would like the ability to leverage this RLS when publishing a report/dataset from Power BI Desktop (using DirectQuery connection to the database...
SQL Server 2016 has row level security with the use of Security Profiles and Session Context. If PowerBI could set a session context variable after connecting with Direct Query then RLS would be properly applied in SQL Server and not PowerBI. We could set the approriate session context variable as part of the Assess Token passed to the embedded report.
