https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1579#M443 <P>username() doesn't work in the service, SSAS is currently the only supported option for row level security</P> Wed, 29 Jul 2015 23:06:10 GMT andre 2015-07-29T23:06:10Z https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1565#M438 <P>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?</P><P>&nbsp;</P><P>Thanks...</P> Wed, 29 Jul 2015 21:41:03 GMT https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1565#M438 TePe 2015-07-29T21:41:03Z https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1571#M440 <P>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:</P><P><A href="https://support.office.com/en-US/article/USERNAME-Function-DAX-8fd30f8a-7daa-42de-a7f7-c569f172a016" target="_blank">https://support.office.com/en-US/article/USERNAME-Function-DAX-8fd30f8a-7daa-42de-a7f7-c569f172a016</A></P><P>&nbsp;</P><P><FONT size="2">Would messy I am sure and probably wouldn't prevent them from viewing the backend data if they could download it.</FONT></P> Wed, 29 Jul 2015 22:12:26 GMT https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1571#M440 Greg_Deckler 2015-07-29T22:12:26Z https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1574#M442 <P>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?</P> Wed, 29 Jul 2015 22:23:52 GMT https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1574#M442 TePe 2015-07-29T22:23:52Z https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1579#M443 <P>username() doesn't work in the service, SSAS is currently the only supported option for row level security</P> Wed, 29 Jul 2015 23:06:10 GMT https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1579#M443 andre 2015-07-29T23:06:10Z https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1585#M447 <P>Ah well...</P> Thu, 30 Jul 2015 01:00:52 GMT https://community.fabric.microsoft.com/t5/Power-Query/User-Security-Options/m-p/1585#M447 Greg_Deckler 2015-07-30T01:00:52Z