Forum Discussion
Preview a report on a security level
You want to put in place static RLS. You do not need a table Spain Manager. In the security roles you create add the filter on the specific country of your DIM Table you want to focus, not on users email AND not on the table you created.
For ex for Spain, choose something "MarketCode equals SPAIN". You add the specific users once you publish the reprot to Power Bi services
You want to put in place static RLS. You do not need a table Spain Manager. In the security roles you create add the filter on the specific country of your DIM Table you want to focus, not on users email AND not on the table you created.
For ex for Spain, choose something "MarketCode equals SPAIN". You add the specific users once you publish the reprot to Power Bi services
I managed to set the roles using the Country column. Thank you for your advice Alex!