Forum Discussion
Running .pbix file to multiple computers with different roles
No, it is not possible. But you can achieve somewhat automation (less manual work) by just creating one role and passing UPN property of the logged in user via that role to the user security table where you will have Employee Manager relationship mapped. Check out below link on using Username() function of DAX for RLS.
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
Best Regards,
Herbert
Thanks for the reply but i want it in Power BI desktop and restrict user on the basis of report. is it possible??
v-haibl-msftMicrosoft Employee
No, it is not possible. But you can achieve somewhat automation (less manual work) by just creating one role and passing UPN property of the logged in user via that role to the user security table where you will have Employee Manager relationship mapped. Check out below link on using Username() function of DAX for RLS.
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
Best Regards,
Herbert