Forum Discussion

zaidmasad's avatar
zaidmasad
Icon for Helper III rankHelper III
8 years ago

Applying Row level security based on users country in dashboards

Hello,   I have two tables, one contains each country and its revenues, the other contains the managers and their countries as below:   In the manager field there is the Email of each manager...
Need Help
Show and Tell
zaidmasad's avatar
zaidmasad
Icon for Helper III rankHelper III
8 years ago

Hello M_Matuszewski

 

I have tried this, but when I test as role, I dont see any data in the dashboard.

M_Matuszewski's avatar
M_Matuszewski
Frequent Visitor
8 years ago

sure, it won't work while testing, because having a role defined like: [Email] = USERNAME() it will check the actual logged user. Try to manipulate your dataset, add a test email adress as a manager (to which you have access to), publish the report to the Power BI Online Service, and then log in with that test user ;-)