Have a mechanism for support row level security (RLS) with Power BI Embedded
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.
