User Security Options

[TePe]

So I understand that Power BI can leverage SSAS's security by passing the Effective User Name to the server. Is this currently the only option to reuse the same dashboard for users who have different rights on seeing data?

Thanks...

[Greg_Deckler]

In theory, you could build the username into your data tables as far as who is allowed to see what rows and use DAX USERNAME() function as shown here:

https://support.office.com/en-US/article/USERNAME-Function-DAX-8fd30f8a-7daa-42de-a7f7-c569f172a016

Would messy I am sure and probably wouldn't prevent them from viewing the backend data if they could download it.

[TePe]

hmm... How would I do the filtering then? I'm sure I can build up a "permission table", link it in the data model, find out the user name (with the formula you provided) and then I need to filter the user from the permission table. Any hint how to do that?

[andre]

username() doesn't work in the service, SSAS is currently the only supported option for row level security

[Greg_Deckler]

Ah well...