Gregory Deckler on 19 May 2016 02:35:15
Have a mechanism for support row level security (RLS) with Power BI Embedded
- Comments (9)
RE: Support RLS for Power BI Embedded
Is there something in place to show the data belonging to an user exclusively yet?
I would need a solution where embedding a dashboard in an organization it recognized the user and showed its own data
RE: Support RLS for Power BI Embedded
has this been done for embedded dashboards yet? if not is there an idea request for it yet?
RE: Support RLS for 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.
RE: Support RLS for Power BI Embedded
I dont think there is a good way to handle this. I agree that multi-tenant, RLS and user level data filter.. all these are the most important features to use powerbi embedded. All other use cases are just fancy stuff...
No one is going to user a static powerbi report in a SaaS or any other system. We need some good way to handle this.
RE: Support RLS for Power BI Embedded
Filtering client side via URL parameters isn't enough. The other way I could think is with many workspaces but that would require manual steps per role and wouldn't really work if you can be in multiple roles.
This is a great suggestion.
RE: Support RLS for Power BI Embedded
'+1 for this, would be great
RE: Support RLS for Power BI Embedded
Same business need here ... this scenario is required by many of my customers
RE: Support RLS for Power BI Embedded
This is essential for the reports that we are planning to role out.
RE: Support RLS for Power BI Embedded
This would be extremely powerful and useful to us.