Forum Discussion
AnetaK
Helper V
Helper VRLS: facts or only dim?
Hello,
I have three fact tables and a dim table "Country".
I want to create roles for specific countries.
Can I filter only the Country table or should I filter all the fact tables?
I've filtered only a dim table and used the "View as roles" option.
Everything looks ok in PBI Desktop, but I'am not sure if the Dataset in the PBI Service is completely secured.
- If your country dim is filtering all facts table through relationships, then you should be fine in Service also.
Just ensure to add users to their roles else they will see blank.
1 Reply
AnkitBISolution Sage
If your country dim is filtering all facts table through relationships, then you should be fine in Service also.
Just ensure to add users to their roles else they will see blank.